Select rows from table A that do not exist in table B
select from A where id not in (select id from B)
