Skip to Content
0
Feb 28, 2011 at 07:43 AM

Item Selection from Table

13 Views

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