Hi Experts,
In OWOR table how to get Parent Item Description.
SELECT T0.[DocNum], t0.U_Vcode, t0.U_Vname, T0.[ItemCode], T0.[PlannedQty] as 'FIPQ', T0.[CmpltQty], T0.[RjctQty], T0.[PostDate], T0.[DueDate], T1.[ItemCode] as 'Child Item', T1.[BaseQty], T1.[PlannedQty], T1.[wareHouse] FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.[U_Vname] = [%0] and t1.itemcode = 'Labour'
In above query i want parent item name/description. how to get this?
Regards,
Ravi