Hi, Maybe you can try this syntax. I'm not sure, but it eventually perform better: delete from company_alias USING comprmwhere company_alias.company_id =comprm.id
Cheers,
Marc