多表联系关系的update语句

多表关联的update语句

ORACLE?UPDATE?多表关联的update语句

??--?update?超过2个值
???update?customers?a???--?使用别名
???set????(city_name,customer_type)=(select?b.city_name,b.customer_type?
?????????????????????????????????????from???tmp_cust_city?b?
?????????????????????????????????????where??b.customer_id=a.customer_id)
???where??exists?(select?1?
??????????????????from???tmp_cust_city?b
??????????????????where??b.customer_id=a.customer_id
?????????????????)

?

-----------------------------------------