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
table1 (id, name)
table2 (id, name)
Query:
SELECT name
FROM table2
-- that are not in table1 already
© Stack Overflow or respective owner