Skip to Content
0
Jun 10, 2020 at 04:21 AM

Query returning duplicate results

51 Views

Hey,

Could anyone tell me why the following query would be returning 3 identical results?

SELECT T1."callID", T1."BPBillAddr", T1."custmrName", T1."NumAtCard", T1."closeDate", T1."resolution",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