Subject Re: update from 2 tables
Author Milan Babuskov
--- In, "Adam" <s3057043@...> wrote:
> --- In, "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.