Subject Re: [firebird-support] Re: Using Nested Selects
Author Dimitry Sibiryakov
> I tried the nested select to check the speed. I actually want to
> delete all the transactions and their corresponding TransactionItems
> and so this query was going to be
> Delete from TransactionItems ........
> That is why I considered a nested select as I could not delete
> with a join!

But you can delete with cascade foreign key.