codice:
select * from tabella1
left join tabella2
on tabella1.id = tabella2.id
where tabella2.id is null