Delete orphan records not referenced by any parent.

Answer preview

Orphans are found with an anti-join — child rows whose foreign key value has no matching parent — and deleted with the same predicate in a DELETE.…