Could someone confirm this will delete orphan records from the child table Component where the Analysis and version don't exisit in the paretn table.
Parent key field are Name, Version
Child is Analayis, Version
component.analysis = analysis.name
DELETE ANALYSIS_VARIATION c where NOT EXISTS (select name, version from analysis a where c.analysis = a.name and c.version=a.version)