mysql updatae select结果
UPDATE tf_c_agency_credit a
INNER JOIN (
SELECT a.agency_id AS agency_id, SUM(CASE
WHEN a.plase_state = 1 THEN IFNULL(a.valuation_fee, 0)
END) AS entrance_fee
, SUM(IFNULL(a.valuation_fee, 0)) AS all_...
原创
2018-12-27 19:00:12 ·
292 阅读 ·
1 评论