Everytime, I run this query I get 3 or 4 duplicate records. I can't figure out what is going on. Any help would be appreciated. Thanks
[CODE=sql]
SELECT dbo.INVOICES.OR DER_NO AS "ORDER_NO", dbo.INVOICES.SA LES_REP AS "SALES_REP" , dbo.INVOICES.TE RMS AS "TERMS", convert (varchar,cast (dbo.INVOICES.I NV_AMOUNT as money),1) AS "INV_AMOUNT ", dbo.INVOICES.ST ATUS AS "STATUS", dbo.TRCK_GRP.NA ME AS "GROUP NAME", dbo.TRCK_CHO.RA NK AS "CHOICE RANK", dbo.TRCK_CHO.NA ME AS "CHOICE NAME", dbo.TRCK_CHO.IS _DEFAULT AS "IS_DEFAULT ", dbo.TRCK_GRP.RA NK AS "GROUP RANK", convert(varchar ,dbo.TRCK_SEL.M ODIFIED_DATE,10 1) AS "MODIFIED_DATE" , dbo.TRCK_SEL.SU B_CODE AS "SUB_CODE", dbo.TRCK_SEL.SU B_TYPE AS "SUB_TYPE", dbo.INVOICES.OR DER_DATE AS "ORDER_DATE ", dbo.TRCK_SEL.GR OUP_CODE AS "GROUP_CODE ", dbo.TRCK_CHO.CH OI_CODE AS "CHOI_CODE" , dbo.CUST.NAME AS "NAME", dbo.PERSONAL.PF IRST AS "PFIRST", dbo.PERSONAL.EM AIL AS "EMAIL" FROM ((((((dbo.TRCK_ GRP INNER JOIN dbo.TRCK_CHO ON dbo.TRCK_GRP.GR OUP_CODE = dbo.TRCK_CHO.GR OUP_CODE) INNER JOIN dbo.TRCK_SEL ON dbo.TRCK_CHO.CH OI_CODE = dbo.TRCK_SEL.CH OI_CODE) INNER JOIN dbo.INVOICES ON dbo.TRCK_SEL.SU B_CODE = dbo.INVOICES.OR DER_NO) INNER JOIN dbo.CUST ON dbo.INVOICES.CU ST_CODE = dbo.CUST.CUST_C ODE) INNER JOIN dbo.ADDRESS ON dbo.CUST.CUST_C ODE = dbo.ADDRESS.CUS T_CODE) LEFT OUTER JOIN dbo.PERSONAL ON dbo.PERSONAL.ID NO = dbo.INVOICES.SA LES_REP) WHERE dbo.INVOICES.ST ATUS = 8 AND dbo.TRCK_GRP.NA ME LIKE 'CREDIT CARD AUTHORIZATION' AND dbo.TRCK_CHO.NA ME IN ( 'AWAITING SIGNED CC AUTHORIZATION FORM' , 'CREDIT CARD DECLINED / EXPIRED' ) AND dbo.INVOICES.TE RMS = 'CC' AND dbo.INVOICES.PA ID = 'F' AND convert(varchar ,dbo.TRCK_SEL.M ODIFIED_DATE,10 1) = '{%Current Date MM/DD/YYYY%}' ORDER BY dbo.INVOICES.OR DER_NO ASC[/CODE]
[CODE=sql]
SELECT dbo.INVOICES.OR DER_NO AS "ORDER_NO", dbo.INVOICES.SA LES_REP AS "SALES_REP" , dbo.INVOICES.TE RMS AS "TERMS", convert (varchar,cast (dbo.INVOICES.I NV_AMOUNT as money),1) AS "INV_AMOUNT ", dbo.INVOICES.ST ATUS AS "STATUS", dbo.TRCK_GRP.NA ME AS "GROUP NAME", dbo.TRCK_CHO.RA NK AS "CHOICE RANK", dbo.TRCK_CHO.NA ME AS "CHOICE NAME", dbo.TRCK_CHO.IS _DEFAULT AS "IS_DEFAULT ", dbo.TRCK_GRP.RA NK AS "GROUP RANK", convert(varchar ,dbo.TRCK_SEL.M ODIFIED_DATE,10 1) AS "MODIFIED_DATE" , dbo.TRCK_SEL.SU B_CODE AS "SUB_CODE", dbo.TRCK_SEL.SU B_TYPE AS "SUB_TYPE", dbo.INVOICES.OR DER_DATE AS "ORDER_DATE ", dbo.TRCK_SEL.GR OUP_CODE AS "GROUP_CODE ", dbo.TRCK_CHO.CH OI_CODE AS "CHOI_CODE" , dbo.CUST.NAME AS "NAME", dbo.PERSONAL.PF IRST AS "PFIRST", dbo.PERSONAL.EM AIL AS "EMAIL" FROM ((((((dbo.TRCK_ GRP INNER JOIN dbo.TRCK_CHO ON dbo.TRCK_GRP.GR OUP_CODE = dbo.TRCK_CHO.GR OUP_CODE) INNER JOIN dbo.TRCK_SEL ON dbo.TRCK_CHO.CH OI_CODE = dbo.TRCK_SEL.CH OI_CODE) INNER JOIN dbo.INVOICES ON dbo.TRCK_SEL.SU B_CODE = dbo.INVOICES.OR DER_NO) INNER JOIN dbo.CUST ON dbo.INVOICES.CU ST_CODE = dbo.CUST.CUST_C ODE) INNER JOIN dbo.ADDRESS ON dbo.CUST.CUST_C ODE = dbo.ADDRESS.CUS T_CODE) LEFT OUTER JOIN dbo.PERSONAL ON dbo.PERSONAL.ID NO = dbo.INVOICES.SA LES_REP) WHERE dbo.INVOICES.ST ATUS = 8 AND dbo.TRCK_GRP.NA ME LIKE 'CREDIT CARD AUTHORIZATION' AND dbo.TRCK_CHO.NA ME IN ( 'AWAITING SIGNED CC AUTHORIZATION FORM' , 'CREDIT CARD DECLINED / EXPIRED' ) AND dbo.INVOICES.TE RMS = 'CC' AND dbo.INVOICES.PA ID = 'F' AND convert(varchar ,dbo.TRCK_SEL.M ODIFIED_DATE,10 1) = '{%Current Date MM/DD/YYYY%}' ORDER BY dbo.INVOICES.OR DER_NO ASC[/CODE]
Comment