优化 SQL 查询：计算工时和工资总额
SELECT pool.*, COALESCE(SUM(record.SUM_WORK_HOUR), 0) AS '总工时', COALESCE(SUM(record.SUM_WORK_WAGE), 0) AS '总工资' FROM labor_worker_pool AS pool LEFT JOIN labor_work_record AS record ON pool.ID = record.WORKER_POOL_ID AND record.SETTLE_STATUS = 1 GROUP BY pool.ID
原文地址: https://www.cveoy.top/t/topic/oUyU 著作权归作者所有。请勿转载和采集!