>I usually run SELECT with the same conditions and check result to see if it does what I want.

Good point.

>
>>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.