sql 一个结果集 如何跟另一个集 join
答案:3 悬赏:10 手机版
解决时间 2021-03-28 21:22
- 提问者网友：蔚蓝的太阳
- 2021-03-28 17:22
sql 一个结果集 如何跟另一个集 join
最佳答案
- 五星知识达人网友：逐風
- 2021-03-28 18:25
select * from
(
select * from
(
select * from (
select attdaydata.EmpNo,EmpName,dtname,EmpTypeName,PartName,
sum(OverTime) as skjb,sum(OverTime1+OverTime2+OverTime3) as zsjb,sum(ReqOverTime)as webflow
from attdaydata
join perEmployee on attdaydata.EmpID=perEmployee.EmpID where CONVERT(varchar(12) ,YYMMDD, 112 )
between 20140223 and 20140301 and EmpTypeName='不限36小时'
GROUP BY attdaydata.EmpNo,EmpName,dtname,EmpTypeName,PartName
)
) a,
(select * from
(
select workno,sum(sqzss) as sqzss from view_Overtime3 where wovtdte between 20140223 and 20140301
group by workno
)
) b
where a.empno=b.workno
(
select * from
(
select * from (
select attdaydata.EmpNo,EmpName,dtname,EmpTypeName,PartName,
sum(OverTime) as skjb,sum(OverTime1+OverTime2+OverTime3) as zsjb,sum(ReqOverTime)as webflow
from attdaydata
join perEmployee on attdaydata.EmpID=perEmployee.EmpID where CONVERT(varchar(12) ,YYMMDD, 112 )
between 20140223 and 20140301 and EmpTypeName='不限36小时'
GROUP BY attdaydata.EmpNo,EmpName,dtname,EmpTypeName,PartName
)
) a,
(select * from
(
select workno,sum(sqzss) as sqzss from view_Overtime3 where wovtdte between 20140223 and 20140301
group by workno
)
) b
where a.empno=b.workno
全部回答
- 1楼网友：深街酒徒
- 2021-03-28 19:34
使用union
- 2楼网友：笑迎怀羞
- 2021-03-28 19:22
结果集可以用别名的
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息
大家都在看
推荐资讯