如何合并表
日期：2014-05-17 浏览次数：20549 次
怎么合并表
怎么做成一张??
------解决方案--------------------
不知道你是不要这样的结果
select MONTH(a.SummaryDate) as Date,--每个月
SUM(a.RevenueMoney) as AllMoney--每个月的收入
FROM dbo.Summary AS a
WHERE YEAR(a.SummaryDate)='2012' and --?这里假设你要查?2010年的每月的统计。
a.SId = '001'
GROUP BY
MONTH (a.SummaryDate)
order by (Date) desc
select MONTH(a.SummaryDate) as Date,--每个月
SUM(a.RevenueMoney) as AllMoney--每个月的收入
FROM dbo.Summary_1 AS a
WHERE YEAR(a.SummaryDate)='2012' and --?这里假设你要查?2010年的每月的统计。
a.SId = '001'
GROUP BY
MONTH (a.SummaryDate)
order by (Date) desc
select MONTH(a.SummaryDate) as Date,--每个月
SUM(a.RevenueMoney) as AllMoney--每个月的收入
FROM dbo.Summary_2 AS a
WHERE YEAR(a.SummaryDate)='2012' and --?这里假设你要查?2010年的每月的统计。
a.SId = '001'
GROUP BY
MONTH (a.SummaryDate)
order by (Date) desc
怎么做成一张??
------解决方案--------------------
select MONTH(a.SummaryDate) as Date,
SUM(a.RevenueMoney) as AllMoney
FROM (select summarydate,revenueMoney from dbo.Summary
WHERE YEAR(a.SummaryDate)='2012' and
a.SId = '001' union all
select summarydate,revenueMoney from dbo.summary_1
WHERE YEAR(a.SummaryDate)='2012' and
a.SId = '001' union all
select summarydate,revenueMoney from dbo.summary_2
WHERE YEAR(a.SummaryDate)='2012' and
a.SId = '001')
AS a
GROUP BY
MONTH (a.SummaryDate)
order by (Date) desc
不知道你是不要这样的结果
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
