UPDATE-多表关联-Oracle
1、基本情况;2个表DEMO_A和DEMO_B结构完全一样select * from DEMO_A select * from DEMO_B 2、需求:把DEMO_A中ID与NAME_S与DEMO_B中ID与NAME_S相同的行的AGE、NAME_L、SALARY的值写入DEMO_B中对应的字段。UPDATE DEMO_B BSET (AGE,NAME_L,SALARY) = (SELECT AGE,NAME_L,SALARY FROM DEMO_A A WHERE B.ID
原创
2021-09-30 10:07:35 ·
176 阅读 ·
0 评论