Skip to Content
0
Former Member
Nov 12, 2012 at 09:06 AM

Production Order - Item Description Querry

35 Views

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.