本文介绍如何使用SQL将两张行数不同的表合并为一张表，并展示如何计算总和及保持数据一致性。通过两个SQL查询示例，文章详细解释了如何实现合并操作，并给出最终期望的显示结果。
问题:
怎么把两张行数不同的表合并成一个表？
Sql 为：
select s.stagename sname,
sum(nworkhours) nworkhours,
sum(OVERHOURS) OVERHOURS,
sum(nworkhours+OVERHOURS)
from T_WorkDetails w,
t_stage s
where w.stageid=s.stageid and w.projectid='D0927380468F4A4EE04010AC0C051F15'
group by s.stagename
ORDER by s.stagename
显示为：
第二个SQL 为：
select sum(total) as temptal from (select s.stagename sname,
sum(nworkhours) nworkhours,
sum(OVERHOURS) OVERHOURS,
sum(nworkhours+OVERHOURS) total
from T_WorkDetails w,
t_stage s
where w.stageid=s.stageid and w.projectid='D0927380468F4A4EE04010AC0C051F15'
group by s.stagename
ORDER by s.stagename)
显示为：
想要显示的结果为：
核心思想：select * from (表A,表B)
总体的sql如下：
select * from (select s.stagename sname,
sum(nworkhours) nworkhours,
sum(OVERHOURS) OVERHOURS,
sum(nworkhours+OVERHOURS)
from T_WorkDetails w,
t_stage s
where w.stageid=s.stageid and w.projectid='D0927380468F4A4EE04010AC0C051F15'
group by s.stagename
ORDER by s.stagename) t1,
(select sum(total) as temptal from (select s.stagename sname,
sum(nworkhours) nworkhours,
sum(OVERHOURS) OVERHOURS,
sum(nworkhours+OVERHOURS) total
from T_WorkDetails w,
t_stage s
where w.stageid=s.stageid and w.projectid='D0927380468F4A4EE04010AC0C051F15'
group by s.stagename
ORDER by s.stagename)t2)
注意：行数少的那一张表会自动补齐行数和行数多的那一张表对应
扫一扫
175
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
