17,377
社区成员
发帖
与我相关
我的任务
分享oracle update 多表关联
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
)
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
)
...全文
请发表友善的回复…
发表回复
Dave 2009-10-14
- 打赏
- 举报
多谢楼主分享...
