Hi All,
I have the following Querry, i want to see how much of items were received and how much of items were issued. the items and quantities keep repeating.
SELECT T0.[ItemCode], T0.[Dscription], T0.[Quantity], T1.[ItemCode], T2.[ItemName], T1.[IssuedQty], T2.[BWeight1] FROM IGN1 T0 , WOR1 T1 INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode WHERE T0.[ItemCode] Like 'fs%%' and T1.[ItemCode] Like '%%db%%' and T0.[DocDate] >= '[%0]' and T0.[DocDate] <= '[%1]'
Any help would be appreciated.
Thanks