Hello Experts,
Is it possible to execute a multiple column update using proc sql?. Example Query:
update tableA T
set ( column1,
column2,
column3) = (select S.column1,
S.column2,
S.column3
from tableB S
where S.filter1 = T.Filter1)
This type of update can be executed in Oracle
Thanks for your help.
Pablo.
... View more