Hi all,
I need assistance in the following Query,
SELECT T1.[ItemCode], T2.[ItemName], T1.[IssuedQty], T0.[ItemCode], T2.[ItemName], T0.[CmpltQty]
FROM OWOR T0 INNER JOIN WOR1 T1 ON T0.DocEntry = T1.DocEntry
INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode
WHERE T0.[ItemCode] like '%wip%' and T0.[PostDate] >='[%0]' and T0.[PostDate] <='[%1]'
it's Picking Same description in Both Columns. what did i leave out.