• Try outer join syntax?

     

    SELECT distinct tr.Prcs_dte

    FROM tbl_Tracking tr left outer join Acct_Stats asts

    on tr. prcs_dte = asts. prcs_dte

    where asts. prcs_dte is null

     

    This may work faster.

    Russel Loski, MCSD

    Russel Loski, MCSE Business Intelligence, Data Platform