--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...>
wrote:

>
> > --- In firebird-support@yahoogroups.com, "cbll_lam" <cbll_lam@>
> > wrote:
> > >
> > > Thank you for pointing out my mistake. I must mixing it up with
> > > something else.
> > >
> > > It begs another question: how to do it in FB?
> > >
> > > Any suggestion will be appreciated.
> > >
> > > regards,
> > > bill
> > >
>
> what about
> update a set a.p=(select b.q from b where b.y=a.x);
> Alan
>

That is a lot easier (and standard compliant). Ignore my suggestion.

Adam