u can guess from following example
Select a.*,b.* from
a left outer join b on a.id = b.id
where b.id is null
OR
Select a.*,b.* from
a left outer join b on a.id = b.id
where b.id is not null
Or give details of your table so give u exact output what u needed..
Give votes if satisfied..