Question

2个表的连接作为条件的update该如何写

比如说table1 table2两个表

update table2
set table2.aaa = '1'
where
table2.aaa = table1.bbb
and table1.ccc = '3';

就这种意思，但是这样运行好像不通

Answer 1

update table2 set table2.aaa = '1' where table2.aaa =(select table1.bbb from table1 where table1.ccc = '3')

Answer 2

update table2
set aaa='1'
from table 2 a
left join table1 b
on a.aaa=b.bbb
where a.ccc='3'