Skip to Content
0
May 14, 2013 at 10:35 AM

Query JOIN with relation between RDR1 and DLN1

899 Views

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