I want to check what my error is, which is not syntax, but logic in the query, I am trying to generate a report showing in detail the Items that were quoted, and are going to be used in a car service job. (EX: OIL CHANGE, ALIGNMENT, ETC) The query is for SAP BO.
What happens is that it duplicates the fields for me, and it does not perform the filter of the date that I configure it (I select a date and even so it brings me all the other dates the same)
From already thank you very much.
QUERY=
SELECT T0."CreateDate", T0."U_BoxPatent", T1."ItemCode", T0."U_Branch", T0."U_EstadoOT", T2."draftKey", T1."ItemCode",T1."U_ArtEst", T0."U_EstRec", T1."DocEntry"
FROM "ODBC"."@EXX_ORDT" T0 , QUT1 T1 INNER JOIN OQUT T2 ON T1."DocEntry" = T2."DocEntry"
WHERE T0."U_Branch" IS NOT NULL
AND
T0."U_EstRec" = '[%1]'
OR
T0."CreateDate" between '[%2]' AND '[%3]'