SQL

Lösche alle Daten einer Tabelle welche nicht mit den ander Tabellen verbunden sind (join)

delete from tadressen where id in (select ad.id from tadressen as ad
left join tkunden kp on kp.tpostadresse_id = ad.id
left join tkunden kl on kl.tlieferadresse_id = ad.id
left join tcompany ckp on ckp.tlieferadresse_id = ad.id
left join tcompany ckl on ckl.tlieferadresse_id = ad.id
left join tbaustellen bau on bau.tadressen_id = ad.id
left join tlieferanten lief on lief.tadressen_id = ad.id
left join tangestellte ang on ang.tadressen_id = ad.id

where kp.id is null and kl.id is null and bau.id is null and ckp.id is null and ckl.id is null and lief.id is null  and ang.id is null)