Subject Re: [firebird-support] Delete with join and delete from multiple tables
Author Kjell Rilbe
Not sure it's a good idea with so many id:s but, insert all the id:s
into a temporary table then delete where in (select id from
temptable). Then drop the temp table. Might be a good idea to index the
temp table before executing the delete.


Tim Gahnström wrote:

> I am running firebird 1.5 and cannot seem to figure out how to delete
> from one table based on data in another table.
> How can I implement:
> Delete from A where in (select id from XXX, YYY where z=q)
> When the inline query runs in the hundreds of thousands?
Kjell Rilbe
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64