Subject RE: [firebird-support] Delete with join and delete from multiple tables
Author Helen Borrie
At 02:09 AM 13/09/2007, you wrote:
>Thanks a lot for all the good and prompt responses. I'd say this is
>an unfortunate limitation

Which limitation are you referring to?

>and I hope something more convenient is implemented in the future.

If you mean the limitation that a single DELETE statement cannot
delete rows from multiple tables, that won't change. It is one of
the tenets of SQL logic, not a Firebird limitation.

The limit (1499) on the number of members in a list of constants in
the argument to the IN() predicate is not a limitation for your
situation, since you are not using it.