Skip to Content
Former Member
Feb 11, 2011 at 11:59 AM

Related to Query


I was Create a query for marketing for marketing report in which following fields are coverd Itemcode Itemdesc Qty Sales Value Taxestotal Total CustCode & CustName but in this Query duplication of Itemcode is Occured so How can i Removed this DUPLICATION following is my designed QUERY please suggest me what i do for that

SELECT T0.[ItemCode], T0.[Dscription], T0.[Quantity], (T0.[LineTotal]-T0.[VatSum]) AS "Sales Value", T0.[VatSum], T0.[LineTotal], T1.[CardCode], T1.[CardName] FROM INV1 T0 INNER JOIN OINV T1 ON T0.DocEntry = T1.DocEntry WHERE T0.[DocDate] >=[%0] AND T0.[DocDate] <=[%1] AND T0.[ItemCode] =[%2]