Question

sql 一个结果集 如何跟另一个集 join

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
) as a
--
select * from
(
select workno,sum(sqzss) as sqzss from view_Overtime3 where wovtdte between 20140223 and 20140301 group by workno
)
as b

如何把这两个结果集 连在一起

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
) as a
join
select * from
(
select workno,sum(sqzss) as sqzss from view_Overtime3 where wovtdte between 20140223 and 20140301
group by workno
)
as b
on a.empno=b.workno
) as c

Answer 1

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

Answer 2

结果集可以用别名的

Answer 3

使用union