-- 结果集1
SELECT b.byname, c.alarmTypeName, a.total_ID, a.beginAlarmTime, a.endAlarmTime, a.alarmSpan
FROM tb_alarmInfoTodayTotal a INNER JOIN tb_voiture b ON a.voiture_ID = b.voiture_ID INNER JOIN tb_alarmType c ON a.alarmTypeCode = c.alarmTypeCode
WHERE b.company_ID = @companyId AND a.beginAlarmTime BETWEEN @beginTime AND @endTime-- 结果集2
SELECT b.byname, c.alarmTypeName, a.total_ID, a.beginAlarmTime, a.endAlarmTime, a.alarmSpan
FROM tb_alarmInfoTotal a INNER JOIN tb_voiture b ON a.voiture_ID = b.voiture_ID INNER JOIN tb_alarmType c ON a.alarmTypeCode = c.alarmTypeCode
WHERE b.company_ID = @companyId AND a.beginAlarmTime BETWEEN @beginTime AND @endTime
上面两个结果集,返回的字段相同,表不同,我想把这两个结果集合并,合并成一个结果集后,便于分页显示分页,我可以实现,不知道如何将这两个结果集合并为一个,我试过UNOIN ALL,
SELECT * INTO #tempAlarmInfo
(SELECT * FROM FROM tb_alarmInfoTodayTotal WHERE ....
UNION ALL
SELECT * FROM FROM tb_alarmInfoTotal WHERE ....
)-- 好像不存在这样的语法请教如何合并为一个结果集,存入临时表或表变量中?
(SELECT * FROM tb_alarmInfoTodayTotal WHERE ....
UNION ALL
SELECT * FROM tb_alarmInfoTotal WHERE ....
)atry
SELECT * INTO #tempAlarmInfo
(SELECT * FROM FROM tb_alarmInfoTodayTotal WHERE ....
UNION ALL
SELECT * FROM FROM tb_alarmInfoTotal WHERE ....
) t
SELECT * INTO #tempAlarmInfo from
(SELECT * FROM FROM tb_alarmInfoTodayTotal WHERE ....
UNION ALL
SELECT * FROM FROM tb_alarmInfoTotal WHERE ....
)
a
少了个from