Hi,
I get no result in the T2.ShipDate field when I use this query?? When I change it to T1.Shipdate it's working but i don't get the correct data...
How should i get it working with a join between DLN1 and RDR1?
SELECT T0.CardName ,
T0.[DocNum] as 'Packinglist no.',
T2.[ShipDate] as CRD,
T0.[DocDate] as 'Actual Shipdate'
FROM ODLN T0
INNER JOIN DLN1 T1 ON T0.DocEntry = T1.DocEntry
LEFT JOIN RDR1 T2 ON T1.BaseEntry = T1.DocEntry
WHERE T0.[DocDate] >='20130401' AND T0.[DocDate] <='20130430'
Thanks
Mark