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