Subject Re[6]: [ib-support] Delete where exists problem
Author Alexander Tabakov
>your exists isn't really testing anything
>it says... in plain english
>delete all records from this table where there exists any record in another table

:)) You may laugh but I still don't understand.

First of all if what you say is true why this statement deletes some
times the whole table and sometimes what I realy needed? Data is one
and the same.

Second, I have a "party_id = xxxxx" predicate in the where clause of
the select statement. So why would "exists" work on "any record in another table"?

Nevertheless I admit using IN is a much better idea.

Best regards,
Alexander mailto:saho@...