Using Join Compare two tables

select * from table1 Left join table2 ON table1.name=table2.name where table2.name IS NULL