Subject Re: [ib-support] Delete where exists problem
Author Helen Borrie
At 02:09 PM 20/03/2003 +0200, you wrote:
>I experience some very strange issues with a delete statement like
>delete from table
> exists(select * from .....)
>After executing the statement I get different count of rows deleted
>using the same data. I am using FireBird 1.02 on Win2000 Server.
>Any ideas?

Tell us more about the query.
What's the connection between 'delete from table' and the where clause? Is
the intention to delete all rows from table if the subquery finds that
another table is empty?