Duplicates in PL-SQL statement

[k***@gmail.com]

This sql statement returns duplicate records. Please let me know what I
have to change? I appreciate your help.

SELECT TO_DATE(B.CALL_TIME, 'DD-MON-YY HH:MI:SS AM'), B.BTN, 'N/A',
'N/A','N/A',
C.FIRST_NAME, C.MID_INIT, C.LAST_NAME, C.ADDRESS1, C.ADDRESS2, C.CITY,
C.STATE, C.ZIP,
B.REP_ID, B.VZ_ID, B.CSSC_CENTER_ID,'N/A',D.DISPOS_CODE,'N/A','5',
DECODE(UPPER(B.PROP_SEG_FLAG),'Y','High','N','Low',' ') AS propsegflag,
B.DIFF_OFFERS_PAY,
DECODE(UPPER(B.CREDIT_SCORE_AUTH),'Y','Yes','N','No',' ') AS
creditscoreauth, B.ALTERNATE_PHONE
FROM DT_CALL_DETAIL B, DT_BNF_REP_ADDRESS C, DT_CALL_CODE D WHERE
B.P_TRANSID = D.P_TRANSID AND B.P_TRANSID = C.P_TRANSID AND
B.CALL_REASON='Q' AND D.DISPOS_CODE LIKE '4%' AND
TRUNC(B.CALL_TIME) > '20-APR-05' AND TRUNC(B.CALL_TIME) < '22-APR-05'
/


Thanks & Regards.

[Mark C. Stock]

Post by k***@gmail.com
This sql statement returns duplicate records. Please let me know what I
have to change? I appreciate your help.
SELECT TO_DATE(B.CALL_TIME, 'DD-MON-YY HH:MI:SS AM'), B.BTN, 'N/A',
'N/A','N/A',
C.FIRST_NAME, C.MID_INIT, C.LAST_NAME, C.ADDRESS1, C.ADDRESS2, C.CITY,
C.STATE, C.ZIP,
B.REP_ID, B.VZ_ID, B.CSSC_CENTER_ID,'N/A',D.DISPOS_CODE,'N/A','5',
DECODE(UPPER(B.PROP_SEG_FLAG),'Y','High','N','Low',' ') AS propsegflag,
B.DIFF_OFFERS_PAY,
DECODE(UPPER(B.CREDIT_SCORE_AUTH),'Y','Yes','N','No',' ') AS
creditscoreauth, B.ALTERNATE_PHONE
FROM DT_CALL_DETAIL B, DT_BNF_REP_ADDRESS C, DT_CALL_CODE D WHERE
B.P_TRANSID = D.P_TRANSID AND B.P_TRANSID = C.P_TRANSID AND
B.CALL_REASON='Q' AND D.DISPOS_CODE LIKE '4%' AND
TRUNC(B.CALL_TIME) > '20-APR-05' AND TRUNC(B.CALL_TIME) < '22-APR-05'
/
Thanks & Regards.

without knowing your data or your table constraints, its really not possible
to tell you.

make sure your join conditions are correct
make sure your PKs are correct -- you might actually have duplicate rows

also, this posting does not belong in 'marketplace' -- clarify and repost to
.server

++ mcs