Opposite Of An Inner Join Query

Select * from table1
left join table2 on table1.id = table2.id
where table2.id is null

This should perform better than the left join...is null version. See here and here for comparisons.

select t1.id, t1.name
    from table1 t1
    where not exists(select null from table2 t2 where t2.id = t1.id)