Query result shows duplicate records, what is the issue
Summary
Query result shows duplicate records, what is the issueContent
Query result shows duplicate records, what is the issue?
select a.ORG_ID
, d.PARTY_SITE_NUMBER
, c.PARTY_NAME
, c.CITY
, a.TRX_NUMBER
, to_char(a.TRX_DATE, 'dd.mm.yyyy') TRX_DATE
, b.EXTENDED_AMOUNT
from RA_CUSTOMER_TRX_ALL a
, RA_CUSTOMER_TRX_LINES_ALL b
, HZ_PARTIES c
, HZ_PARTY_SITES d
where
a.CUSTOMER_TRX_ID = b.CUSTOMER_TRX_ID
and a.SHIP_TO_PARTY_ID = c.PARTY_ID
and c.PARTY_ID = d.PARTY_ID
and a.ORG_ID IN (300000002015095,300000002015255)
and a.TRX_DATE BETWEEN :P_From_Date and :P_To_Date
0