update company set comp_primarypersonid=null
where comp_primarypersonid
in (select pers_personid from person where pers_lastname is null and pers_firstname is null)
delete from phone where phon_personid in(select pers_personid from person where pers_lastname is null and pers_firstname is null)
delete from email where emai_personid in
(select pers_personid from person where pers_lastname is null and pers_firstname is null)
delete from address where addr_addressid in (select adli_addressid from address_link where adli_personid in (select pers_personid from person where pers_lastname is null and pers_firstname is null))
delete from address_link where adli_personid in (select pers_personid from person where
pers_lastname is null and pers_firstname is null)
delete from person_link where peli_Personid in (select pers_personid from person where pers_lastname is null and pers_firstname is null)
delete from person where pers_lastname is null and pers_firstname is null
ADDRESSES!
update company set comp_primaryaddressid = null where comp_primaryaddressid
in (select addr_addressid from address where addr_address1 is null)
update person set pers_primaryaddressid = null
where pers_primaryaddressid
in (select addr_addressid from address where addr_address1 is null)
delete from address_link where adli_addressid
in (select addr_addressid from address where addr_address1 is null)