Hi,
Please try this query,
SELECT T0.[AbsEntry], T0.[Name], T0.[PickDate], T3.[DocNum], T3.[DocDate], T2.[ItemCode], T2.[Dscription], T2.[Quantity], T1.[PickQtty], T1.[PickStatus] FROM OPKL T0 INNER JOIN PKL1 T1 ON T0.[AbsEntry] = T1.[AbsEntry] inner join RDR1 T2 on T2.[PickIdNo] = T1.[AbsEntry] INNER JOIN ORDR T3 ON T2.[DocEntry] = T3.[DocEntry] and T1.[OrderEntry] = T3.[DocNum] WHERE T1.[OrderLine] = T2.[LineNum]
Thanks
Add a comment