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 B

SET (AGE,NAME_L,SALARY) = (SELECT AGE,NAME_L,SALARY FROM DEMO_A A WHERE B.ID = A.ID AND B.NAME_S = A.NAME_S )

WHERE EXISTS(SELECT 1 FROM DEMO_A A WHERE B.ID = A.ID AND B.NAME_S = A.NAME_S)

3、结果