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

 

版权声明：本文为sunxi原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/sunxi/p/4588492.html