时间戳

首页 > 技术文章 > Sql语句统计多表个数并求和

Sql语句统计多表个数并求和

sunxi 2015-06-19 14:13 原文

SELECT COUNT(1) FROM 

((SELECT BaseID FROM dbo.Life_cheliang WHERE  BaseCreateDate BETWEEN '2015-6-5' AND '2015-6-11')
UNION
(SELECT BaseID FROM dbo.Life_fangchan WHERE  BaseCreateDate BETWEEN '2015-6-5' AND '2015-6-11')
UNION
(SELECT BaseID FROM dbo.Life_tiaozao WHERE  BaseCreateDate BETWEEN '2015-6-5' AND '2015-6-11')
UNION
(SELECT BaseID FROM dbo.Life_shenghuo WHERE  BaseCreateDate BETWEEN '2015-6-5' AND '2015-6-11')
UNION
(SELECT BaseID FROM dbo.Life_zhaopin WHERE  BaseCreateDate BETWEEN '2015-6-5' AND '2015-6-11')
UNION
(SELECT BaseID FROM dbo.Life_chongwu WHERE  BaseCreateDate BETWEEN '2015-6-5' AND '2015-6-11')
UNION
(SELECT BaseID FROM dbo.Life_shangwu WHERE  BaseCreateDate BETWEEN '2015-6-5' AND '2015-6-11')
UNION
(SELECT BaseID FROM dbo.Life_peixun WHERE  BaseCreateDate BETWEEN '2015-6-5' AND '2015-6-11')
UNION
(SELECT BaseID FROM dbo.Life_piaowu WHERE  BaseCreateDate BETWEEN '2015-6-5' AND '2015-6-11')
) test

 

推荐阅读