Lius
2024-04-18 1b1233fae35e9e28dbec5934858bf438ee519951
sql修改
已修改1个文件
4 ■■■■ 文件已修改
lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/xml/MdcHomeMapper.xml 4 ●●●● 补丁 | 查看 | 原始文档 | blame | 历史
lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/xml/MdcHomeMapper.xml
@@ -127,8 +127,8 @@
        SELECT
            t1.equipment_id,
            t2.equipment_name,
            SUM ( process_long ) processLong,
            SUM ( open_long ) openLong
            SUM ( t1.process_long ) processLong,
            SUM ( t1.open_long ) openLong
        FROM
            mdc_equipment_statistical_info t1
            LEFT JOIN mdc_equipment t2 ON t1.equipment_id = t2.equipment_id