请求将其他两个请求的结果与SQL Server 2005中的GROUP BY子句一起加入

当然，请使用嵌套查询：

select *from (select count(*) as delivery_count, clientid       from deliveries group by clientid) AS view1inner join (select count(*) as action_count, clientid from routeactions group by clientid) AS view2    on view1.clientid = view2.clientid

或者使用新的CTE语法，您可以：

WITH view1 AS (    select count(*) as delivery_count, clientid from deliveries group by clientid), view2 AS (    select count(*) as action_count, clientid from routeactions group by clientid)select * from view1 inner join view2 on view1.clientid = view2.clientid