Sir I have these codes
SELECT distinct T1."DocDate", T1."DocNum", T1."CardCode", T1."CardName", --T2."Quantity", T0."Debit", T0."Credit" from JDT1 T0 inner join OPCH T1 ON T0."TransId" = T1."TransId" AND T0."TransType" = 18 inner join PCH1 T2 ON T2."DocEntry" = T1."DocEntry" where T0."RefDate"='2021-09-16' and T1."DocNum" =353 and (T0."Debit"<>0 or T0."Credit"<>0) and left(T1."CardCode",1)='V' and T1."CANCELED"='N' order by T1."DocDate",T1."DocNum"
The code work fine but When add this column
T2."Quantity",
The every row appear as double like shown here
Please help me how to get single records.