Skip to Content
0
Former Member
Jul 10, 2012 at 11:57 AM

QUERY

59 Views

Dear Experts,

I need one column of ITEM GROUP NAME in Following query.

SELECT T0.[DocEntry], T0.[DocNum], T0.[U_ChallanRef], T0.[DocDate], T1.[ItemCode], T1.[Dscription],

T1.[Quantity], ufd.Descr 'Sub Contract Name', T0.[U_Challan_No], T0.[Comments] FROM OIGN T0

INNER JOIN IGN1 T1 ON T0.DocEntry = T1.DocEntry

LEFT JOIN (select FldValue,Descr from ufd1 where TableID = 'OIGN' AND FieldID = '32') ufd on ufd.FldValue=T0.[U_SubConName]

LEFT JOIN (select FldValue,Descr from ufd1 where TableID = 'OIGN' AND FieldID = '33') UFDADD on UFDADD.FldValue=T0.[U_SubConAdd] where ufd.Descr!='' AND T0.[DocDate] >=[%0] and T0.[DocDate] <=[%1]

Thanks & Regards,

Akshata