急急急！！！求高手指点，Sql server 根据某个字段查询两个表的总记录数？

好了，如下：我下班，要赶公司的班车啦。。

select 

t.UserID,

isnull(sum(Case t.tableName When 'A' Then 1 End),0) as '表A的数目',

isnull(sum(Case t.tableName When 'B' Then 1 End),0) as '表B的数目',

isnull(sum(1),0)

 from (

select UserID,CompanyName as [tName],'A' as tableName from A

union all

select UserID,PersonalName as [tName],'B' as tableName from B) t

Group By t.UserID

执行结果：

可以先将两个表分别分组求和，然後再合并
大致写法如下：
select userid,
sum(case when tb = 'A' then cnt else 0 end ) as 表A的数目
sum(case when tb = 'B' then cnt else 0 end ) as 表B的数目
sum(cnt) as 总数目
from
(select userid,count(*) as cnt,'A' as tb from A group by userid
union all
select userid,count(*) as cnt,'B' as tb from B group by userid) as T
group by userid

select isnull(a.id, b.id) as Userid,
isnull(a.count_A, 0) as 表A的数目,
isnull(b.count_B, 0) as 表B的数目,
isnull(a.count_A, 0) + isnull(b.count_B, 0) as 总数目
from
(select id, count(1) as count_A from A group by id ) a
full join
(select id, count(1) as count_B from B group by id ) b
on a.id=b.id