Hi experts,
am facing prbs in this follwng query while selecting doctype as 's' service query fails but for item it gives output
pls sugest any way to overcum this prob.
SELECT T0.[DocNum], T0.[DocType], T0.[CardCode], T0.[CardName], T1.[ItemCode], T1.[Dscription], T1.[Quantity] FROM [dbo].[OINV] T0 INNER JOIN [dbo].[INV1] T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OITM T2 ON T1.ItemCode = T2.ItemCode INNER JOIN [dbo].[@ITMG] T3 ON T2.U_itmg = T3.Code WHERE T0.[DocType] =[%0]
pls help me for this
ketan