场景
Table A
id | value |
1 | A1 |
2 | A2 |
Table B
id | value |
1 | B1 |
2 | B2 |
SQL:
UPDATE A SET A.VALUE = (SELECT B.VALUE FROM B WHERE B.ID = A.ID)
结果:
Table A
id | value |
1 | B1 |
2 | B2 |
参考资料:http://www.geeksengine.com/article/oracle-cross-table-update.html
场景
Table A
id | value |
1 | A1 |
2 | A2 |
Table B
id | value |
1 | B1 |
2 | B2 |
SQL:
UPDATE A SET A.VALUE = (SELECT B.VALUE FROM B WHERE B.ID = A.ID)
结果:
Table A
id | value |
1 | B1 |
2 | B2 |
参考资料:http://www.geeksengine.com/article/oracle-cross-table-update.html