Subject update from select
Author Nick Upson

I must be Monday morning stupids but I cannot remember/find the syntax
to update one table from another when there are multiple fields

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