| Subject | Re: [ib-support] Delete where exists problem |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-03-20T12:15:20Z |
At 02:09 PM 20/03/2003 +0200, you wrote:
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?
heLen
>Hi,Tell us more about the query.
>
>I experience some very strange issues with a delete statement like
>this:
>
>delete from table
>where
> 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?
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?
heLen