实现将"项目表"中"医保代码"批量修改成"linshi"表中的"医保代码2"
1.oracle写法
update 项目表 a set a.医保代码=(select b.医保代码2 from linshi b where a.项目代码=b.项目代码1) where exists(select 1 from linshi b where a.项目代码=b.项目代码1)
2.sqlserver写法
UPDATE Table_A SET Table_A.col1 = Table_B.col1, Table_A.col2 = Table_B.col2 FROM Some_Table AS Table_A INNER JOIN Other_Table AS Table_B ON Table_A.id = Table_B.id WHERE Table_A.col3 = 'cool'