Integrity constraint

Hi,

I have a developer who has written the following code to delete some records:

DELETE FROM x
WHERE id NOT IN (SELECT id
FROM y)
AND id NOT IN (SELECT id
FROM z);

ORA-02292: integrity constraint (Y_FK) violated - child record found

When there is already a clause in my delete to state do not delete records that are found in table Y, why do I get the integrity constraint error message? Received on Tue Feb 03 2009 - 02:39:34 CST