Skip to Content
0
Jun 19, 2020 at 06:00 AM

Query showing two records

80 Views

Hey I have the following query

SELECT  DISTINCT CAST(T1."resolution" AS varchar(MAX)),T1."callID", T1."BPBillAddr", T1."custmrName", T1."NumAtCard", T1."closeDate", T1.customer,T3.DocEntry,T2.SrcvCallID, T5.DocNum
FROM OSCL T1
LEFT JOIN SCL4 T2 ON T1."callID" = T2."SrcvCallID"
LEFT JOIN INV1 T3 ON T2."Object" = T3."ObjType" AND T2."DocAbs" = T3."DocEntry"
LEFT JOIN OINV T5 ON T5.DocEntry=T3.DocEntry
WHERE T1.callID = '6440'

the result is showing 2 records, one of which has an invoice number and the other one is missing the invoice number. As such the layout print is showing 2 copies of the report. This should only show the 1 record with the invoice.

Any help is appreciated as always :)