问题:SQL1 通过
a
.
project_type
来分组,能查出两条project_type为集成实施类的数据,而SQL2通过
b
.
id
来分组,就获取到了一条数据,为什么呢?
SQL1
SELECT
`b`.`id` AS `id`,
ifnull( `b`.`type`, '未定义' ) AS `project_type`,
sum( `a`.`task_offer` ) AS `task_offer`,
sum( `a`.`task_price` ) AS `task_price`,
sum( `a`.`increase_price` ) AS `increase_price`,
`a`.`status` AS `status`
FROM
( `task` `a` LEFT JOIN `project_type` `b` ON ( ( `a`.`project_type` = `b`.`id` ) ) )
WHERE
( ( `a`.`status` = 2 ) AND ( `a`.`delete_flag` = 0 ) )
GROUP BY
`a`.`project_type`
查询结果:
SQL2
SELECT
`b`.`id` AS `id`,
ifnull( `b`.`type`, '未定义' ) AS `project_type`,
sum( `a`.`task_offer` ) AS `task_offer`,
sum( `a`.`task_price` ) AS `task_price`,
sum( `a`.`increase_price` ) AS `increase_price`,
`a`.`status` AS `status`
FROM
( `task` `a` LEFT JOIN `project_type` `b` ON ( ( `a`.`project_type` = `b`.`id` ) ) )
WHERE
( ( `a`.`status` = 2 ) AND ( `a`.`delete_flag` = 0 ) )
GROUP BY
`b`.`id`
查询结果: