SQL Server: Find Values that don't exist in a table

Posted by MacAnthony on Stack Overflow See other posts from Stack Overflow or by MacAnthony
Published on 2010-05-21T21:40:06Z Indexed on 2010/05/21 21:50 UTC
Read the original article Hit count: 146

Filed under:
|

I have a list or set of values that I would like to know which ones do not currently exist in a table. I know I can find out which ones do exist with:

SELECT * FROM Table WHERE column1 IN (x,x,x,x,x)

The set is the values I am checking against. Is there a way to find out which values in that set do not exist in column1? Basically, I'm looking for the inverse of the sql statement above.

This is for a report, so all I need is the values that don't exist to be returned back.

I have and could do this with a left join and putting the values in another table, but the values I check are always different and was hoping to find a solution that didn't involve clearing a table and inserting data first. Trying to find a better solution for me if one exists.

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql