Oracle有相关连的两个数据表某一数据列的相对更新
update A set A.transformer = (select B.area_id from B where A.meteringPointNo = B.meteringpointNo) where exists(select 1 from B where A.meteringPointNo = B.meteringpointNo)Demo SQL注释:Transformer 与 ar
原创
2018-01-16 08:58:29 ·
428 阅读 ·
0 评论