Skip to Content
0
Former Member
Nov 05, 2012 at 10:32 AM

Production Querry

25 Views

Dear all,

i have the following query

SELECT T1.[ItemCode], T1.[IssuedQty], T2.[BVolume], T0.[ItemCode], T0.[CmpltQty], T2.[SVolume] FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode WHERE T0.[DocNum] ='18368'

on SVolume it's picking SVolume of T1.[ItemCode], i want it to pick SVolume of T0.[ItemCode]. what is missing.