select A.* from A join B on A.id=B.id where B.id is null;
select A.* from A left outer join B on A.id=B.id where B.id is null;
select A.* from A right outer join B on A.id=B.id where B.id is null;
select A.* from A inner join B on A.id=B.id where B.id is null;