select * from A inner join B on(A.id = B.id)
select * from A left join B on(A.id = B.id)
select * from A right join B on(A.id = B.id)
select * from A left join B on(A.id = B.id) where B.id is null
select * from A right join B on(A.id = B.id) where A.id is null
select * from A full outer join B on(A.id = B.id)
select * from A full outer join B on(A.id = B.id) where A.id is null or B.id is null