Can someone help me understand how to convert the following update statement to ANSI SQL?
I'm not sure how to do a join in an update statement with a table in a subquery.
update table1 a
set col1 = 'AAA'
where exists ( select 1
from table2 b
where b.col2 = a.col2 );
Thanks for your advice.
Steve