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 A.id in (select id from
temptable). Then drop the temp table. Might be a good idea to index the
temp table before executing the delete.

Kjell

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 A.id in (select id from XXX, YYY where z=q)
>
> When the inline query runs in the hundreds of thousands?

--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64