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

Question

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

Query:

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

Answer 1

SELECT t1.name
FROM table1 t1
LEFT JOIN table2 t2 ON t2.name = t1.name
WHERE t2.name IS NULL

Answer 2

SELECT name
FROM table2
WHERE name NOT IN
    (SELECT name 
     FROM table1)

or

SELECT name 
FROM table2 
WHERE NOT EXISTS 
    (SELECT * 
     FROM table2 
     WHERE table1.name = table2.name)

See this question for 3 techniques to accomplish this

Answer 3

This is pure set theory which you can achieve with the minus operation.

select id, name from table1 minus select id, name from table2