Sep 15, 2014 07:51 AM|PatriceSc|LINK
Show really the full statement?
For now it seems you delete all telephones for a person and then delete some telephones but we don't know which criteria you used (could it be that you really try to delete them all?) Do you want to delete then all unused telephones?
It could be something such as :
DELETE Telephone FROM Telephone WHERE NOT EXITS(SELECT 1 FROM Person_Has_Telephone WHERE Telephone_id=id) that is you delete all telephones which are not found in the person_has_telephone table.