update 2 columns by doing inner 2-column query

Posted on 16th Feb 2014 by admin

Hi,
is something like this possible?

update contract_all set col1,col2 =
(SELECT col1,col2 FROM tab1 WHERE id = 141 and status='a')
where co_id=141;

Thanks

Other forums