Duplicates in SQL statement

From: <krallabandi_at_gmail.com>
Date: 22 Apr 2005 12:08:32 -0700
Message-ID: <1114196912.546077.15460@z14g2000cwz.googlegroups.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. Received on Fri Apr 22 2005 - 14:08:32 CDT