--- In firebird-support@yahoogroups.com, "Adam" <s3057043@...> wrote:

> --- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@>
> > 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).

And a lot slower.

> Ignore my suggestion.

Your suggestion is quite valid and something like that is useful
whenever there is a need for speed.

</M>