• Shouldnt the NOT IN be in the Where clause as the column you are filtering on is not directly related to the Join.

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices