| Subject | Re: Delete with join and delete from multiple tables |
|---|---|
| Author | Adam |
| Post date | 2007-09-12T12:18:45Z |
--- In firebird-support@yahoogroups.com, Tim Gahnström
<tim.gahnstrom@...> wrote:
discovered it can be slow.
On Firebird 1.5, the only other real option is to a stored procedure,
using a for select loop to identify the records of interest then
issuing a delete for each record. With Firebird 2 you can use execute
block syntax as an alternative.
Adam
<tim.gahnstrom@...> wrote:
>delete from one table based on data in another table.
> Hi
>
> I am running firebird 1.5 and cannot seem to figure out how to
>This is the only way unfortunately, and as you have probably
> How can I implement:
>
> Delete from A where A.id in (select id from XXX, YYY where z=q)
>
discovered it can be slow.
On Firebird 1.5, the only other real option is to a stored procedure,
using a for select loop to identify the records of interest then
issuing a delete for each record. With Firebird 2 you can use execute
block syntax as an alternative.
Adam