UPDATE bd_fr_if AS a,
(
SELECT
SUM(acre.ACRE_AREA) as fA,
us.id as uid
FROM
bd_ac_io acre
LEFT JOIN bd_fr_if fam ON fam.id = acre.FR_IO_ID
LEFT JOIN bd_ur_if us ON us.id=fam.UR_IO_ID
WHERE
us.DEL_FLAG=0
GROUP BY us.id
) AS h
SET a.all_area = h.fA
WHERE
a.USER_INFO_ID = h.uid
mysql根据一个表数据修改另一个表
最新推荐文章于 2023-06-19 20:55:31 发布