Thanks for the response. Though I learned from the article, it did not help me resolve me issue. I've double checked and we are only using merge and...

Kind of a DUH! moment for me. Thanks. This is exaclty what I needed.

Because you are performing an outer join, the data not contained in the upload table will show nulls, so you can test for null.

select distinct p.first_name

,p.last_name

,p.people_code_id

from people as p...