本文介绍了一种使用SQL进行跨表联接查询的方法，通过连接task_info、staff_info及mt_info三张表，按mt_name与staff_name分组并汇总effort字段的总和。此查询适用于特定项目编号为'2'的情况。
select mt_name,staff_name,sum(effort) sum
from task_info,staff_info,mt_info
where task_info.task_sril=staff_info.staff_sril
and task_info.mt_sril=mt_info.mt_sril
and task_info.pro_sril='2'
group by cube(mt_name,staff_name);
from task_info,staff_info,mt_info
where task_info.task_sril=staff_info.staff_sril
and task_info.mt_sril=mt_info.mt_sril
and task_info.pro_sril='2'
group by cube(mt_name,staff_name);
扫一扫
829
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
