Skip to Content
0
Oct 05, 2021 at 11:30 AM

Join Problem

104 Views Last edit Oct 05, 2021 at 11:35 AM 2 rev

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.

Attachments

untitled.png (34.7 kB)