How to select all records from one table that do not exist in another table?

Posted by z-boss on Stack Overflow See other posts from Stack Overflow or by z-boss
Published on 2010-04-21T20:18:25Z Indexed on 2010/04/21 20:23 UTC
Read the original article Hit count: 187

Filed under:
|
|

table1 (id, name)
table2 (id, name)

Query:

SELECT name   
FROM table2  
-- that are not in table1 already

© Stack Overflow or respective owner

Related posts about sql

Related posts about tsql