Skip to Content
0
Aug 16, 2012 at 10:46 AM

need sale order docnum in query?????

19 Views

SELECT distinct T0.Docentry,t0.docnum,T0.docdate,T1.ItemCode, T1.Dscription, T1.U_jobno, t0.filler,T1.WhsCode, T1.Quantity,T0.Jrnlmemo FROM OWTR T0 INNER JOIN WTR1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode INNER JOIN OWHS T3 ON T0.Filler = T3.WhsCode INNER JOIN OITW T4 ON T2.ItemCode = T4.ItemCode where T1.U_jobno like N'%[%0]%'