Thanks for the help everyone. I was stuck on the idea that I could do
something like
update table1
set f1, f2, f3
values (select fa, fb, fc from table2 where table1.id = table2.id)

On 20/08/07, Nick Upson <nick.upson@...> wrote:
> Hi,
>
> I must be Monday morning stupids but I cannot remember/find the syntax
> to update one table from another when there are multiple fields
> involved.
>
> I got "update table1 set field1 = (select field2 from table2 where
> ...)" but I have about 12 fields involved.
>
> Could someone more awake please post an example or pointer to one, thanks
>