SELECT COUNT(*) AS AllCount,t.AssignedCount,(COUNT(*)-t.AssignedCount) AS
UnassignedCount
FROM 药品表
jOIN
(
SELECT COUNT(*) AS
AssignedCount
FROM 质量分析分配表
)as t on 1=1
group by
t.AssignedCount
【原】sql 查询结果合为一行,布布扣,bubuko.com
原文：http://www.cnblogs.com/gates/p/3714101.html