Skip to Content
0
Jul 19, 2017 at 01:49 PM

QUERY ORDR ODLN OINV

2986 Views Last edit Aug 22, 2017 at 12:51 PM 2 rev

I need to create a query that one of the Sales order, delivery and invoice. But do not double the lines. This duplicates me. Try other conditions but it does not work.

FROM OINV T0 JOIN INV1 T1 ON T0."DocEntry" = T1."DocEntry" INNER JOIN DLN1 T2 ON T1."BaseEntry" = T2."DocEntry" INNER JOIN ODLN T3 ON T2."DocEntry" = T3."DocEntry" INNER JOIN RDR1 T4 ON T2."BaseEntry" = T4."DocEntry" INNER JOIN ORDR T5 ON T4."DocEntry" = T5."DocEntry"