help Left Join

[piero.mac]

select *
from tab1
left join tab2 on tab1.id = tab2.id
where tab1.id IS NOT NULL
AND tab2.id IS NULL