17,377
社区成员
发帖
与我相关
我的任务
分享
UPDATE sde.fw_h t SET t.scjzmj =(SELECT x.flarea FROM common.em_house_t x WHERE x.location_name = t.zl),
t.scftjzmj =(SELECT x.co_flarea FROM common.em_house_t x WHERE x.location_name = t.zl) ,
t.sctnjzmj =(SELECT (x.flarea - x.co_flarea) AS area FROM common.em_house_t x WHERE x.location_name = t.zl) ,
t.ycjzmj =(SELECT x.p_flarea FROM common.em_house_t x WHERE x.location_name = t.zl),
t.ycftjzmj =(SELECT x.p_co_flarea FROM common.em_house_t x WHERE x.location_name = t.zl),
t.yctnjzmj =(SELECT (x.p_flarea - x.p_co_flarea) AS p_area FROM common.em_house_t x WHERE x.location_name = t.zl)
WHERE t.zl LIKE '%金色嘉园%'
-- 可以一次更新多列,最后再加一个 exists
UPDATE sde.fw_h t
SET (scjzmj, scftjzmj ) = (select flarea ,co_flarea from common.em_house_t x WHERE x.location_name = t.zl)
where exists(select * from common.em_house_t x WHERE x.location_name = t.zl)
UPDATE sde.fw_h t SET (t.scjzmj,t.scftjzmj,t.sctnjzmj,t.ycjzmj,t.ycftjzmj,t.yctnjzmj)=
(SELECT x.flarea,x.co_flarea,(x.flarea - x.co_flarea),x.p_flarea,x.p_co_flarea,(x.p_flarea - x.p_co_flarea)
FROM common.em_house_t x WHERE x.location_name = t.zl)
WHERE t.zl LIKE '%金色嘉园%'