Subject Re: [firebird-support] Re: Delete with join and delete from multiple tables
Author Helen Borrie
At 10:41 AM 13/09/2007, Adam wrote:
>--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
> >
> > At 02:09 AM 13/09/2007, you wrote:
> > >Hi
> > >
> > >
> > >
> > >Thanks a lot for all the good and prompt responses. I'd say this is
> > >an unfortunate limitation
> >
> > Which limitation are you referring to?
>
>Hi Helen,
>
>I think he is referring to the optimiser always starting with the top
>table.
>
>For example:
>
>delete from a
>where a.id in
>(
> select b.id
> from b
> join c on (b.cid = c.id)
>)

I don't think so, since the comment was top-posted to *my* reply,
which had better advice than this...

./hb