update more than 2 columns using select
I want to update two or more columns of a table using the values from
another table using a single update.
It would be something like:
update table1 set (col1, col2)= ( select col1, col2 from table2 where
col3='aa' )
where col3='aa'
I've already seen that working some time ago, but I'm not remembering
the exact syntax now,
Thanks in advance,
--
Ricardo Palmeira
Tribunal de Contas do Estado de Pernambuco
mailto:palmeira@tce.pe.gov.br