I want to delete all bad child records in Insurances for empty Carriers or XXXXXXXX Carriers. I do

DELETE FROM Insurances where cCarrier_Branches_fk ;
in (select cCarrier_Branches_pk from Carrier_Branches ;
inner Join Carriers on Carrier_Branches.cCarriers_fk = Carriers.cCarriers_pk ;
where EMPTY(cCarrier_Name) ;
OR 'XXX' $ cCarrier_Name)

I then checked number of deleted records and it's too big (but I didn't check it before running this code). Am I right here?

Thanks.