Re: What's the fastest way to do this?

On Mon, 12 Nov 2001 11:58:27 -0800, Orion <o2(at)trustcommerce(dot)com>
wrote:
>[...]
>UPDATE test
> SET description = x.description
> FROM test AS rt, test_tmp AS x
> WHERE rt.code = x.code;
This seems to work:
UPDATE test SET description = x.description
FROM test_tmp x
WHERE test.code = x.code;

Kind regards
Carl van Tast