>
> 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
>

update table1 set
field1 = (select fileld2 from table2 where...),
field2 = (select field3 from table2 where...),
...
where table1...

Mondays can be awful :)

Sasha