sql 一个结果集 如何跟另一个集 join 如何将多条sql查询的结果集并到同一个结果集？这些结果集有公...
作者&投稿：姓姣 （若有异议请与网页底部的电邮联系）
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
结果集可以用别名的
使用union
sql 如何把一个查询结果当作一个表来查询?~
(
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
结果集可以用别名的
使用union
sql 如何把一个查询结果当作一个表来查询?~
用内连接
select * from 表1
join 表2
on 公共字段的连接条件
join 表3
on 公共字段的连接条件
···
表1 2 3是你查询出的结果集
