求一条跨表统计语句，多谢

--> 测试数据：[T1]if object_id('[T1]') is not null drop table [T1]create table [T1]([地区] int,[个人编号] int,[姓名] varchar(1))insert [T1]select 1001,1,'A' union allselect 1001,2,'B' union allselect 1002,3,'C' union allselect 1002,4,'D' union allselect 1003,5,'E'--> 测试数据：[T2]if object_id('[T2]') is not null drop table [T2]create table [T2]([个人编号] int,[建档日期] datetime)insert [T2]select 1,'2011-01-03' union allselect 2,'2011-01-04' union allselect 3,'2011-01-05' union allselect 4,'2011-01-06' union allselect 5,'2011-01-07'with tas(select a.地区,a.个人编号,b.建档日期 from [T1] a full join [T2] b on a.个人编号=b.个人编号)select 地区,COUNT(1) as 总人数,(select COUNT(1) from t b where a.地区=b.地区 and b.建档日期 between '2011-01-01' and '2011-01-05') as 时间范围内建档人数from t agroup by 地区/*地区    总人数    时间范围内建档人数1001    2    21002    2    11003    1    0*/
------解决方案--------------------
SQL code
IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE name = 'tba')BEGIN    DROP TABLE tbaENDGOcreate table tba([地区] int,[个人编号] int,[姓名] varchar(1))insert tbaselect 1001,1,'A' union allselect 1001,2,'B' union allselect 1002,3,'C' union allselect 1002,4,'D' union allselect 1003,5,'E'IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE name = 'tbb')BEGIN    DROP TABLE tbbENDGOcreate table tbb([个人编号] int,[建档日期] datetime)insert tbbselect 1,'2011-01-03' union allselect 2,'2011-01-04' union allselect 3,'2011-01-05' union allselect 4,'2011-01-06' union allselect 5,'2011-01-07'SELECT A.[地区],COUNT(A.[个人编号]) AS 总人数,CASE WHEN 查询时间范围内建档数 IS NULL THEN 0                                                   ELSE 查询时间范围内建档数 END AS 查询时间范围内建档数FROM tba AS A INNER JOIN tbb AS B ON A.个人编号 = B.个人编号LEFT OUTER JOIN ((SELECT [地区],COUNT([建档日期]) AS 查询时间范围内建档数 FROM tbb,tba WHERE tba.个人编号 = tbb.个人编号 AND [建档日期] BETWEEN '2011-01-01' AND '2011-01-05' GROUP BY [地区])) AS C ON A.地区 = C.地区GROUP BY A.[地区],查询时间范围内建档数ORDER BY A.[地区]地区    总人数    查询时间范围内建档数1001    2    21002    2    11003    1    0