Re: Select Query and Two Tables

[Peter Brawley]

select firstname, surname, email, status
from b
left join a using(email)
where a.email is null;

Read about exclusion joins.