sql两个表结果计算后合并数据_sql 两个sql结果计算-优快云博客

本文介绍如何将两个不同的SQL查询语句合并成一个，以便同时获取来自不同数据表的数据汇总。通过使用FULL JOIN并结合ISNULL函数，实现了单位名称、数量及罚款数量的统一展示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

两个表结果合并：

查询语句1

1	`select unit,count(*)as number from archives_management group by unit`

查询语句2

1	`select fine_units,count(*) as fine_number from fine group by fine_units`

想让两个语句变成一个，然后查询结果是

unit                                     number          fine_number

艾XXXXXXX                         1                        1

奥XXXXXXXX                        1                        0

北京XXXXXXX                        2                      0

select isnull(a.unit,b.fine_units) unit,isnull(a.number,0) number,isnull(b.fine_number,0) fine_number
from (第一个SQL) A FULL JOIN (第二个SQL) b on a.unit=b.fine_units

SELECT isnull(a.e_1,b.f_1) e_1,isnull(a.e_16,b.f_12) e_16,isnull(a.e_17,b.f_13) e_17,isnull(a.e_19,b.f_15) e_19,isnull(a.e_11,0) e_11,isnull(b.f_9,0) f_9
FROM (select e_1,e_16,e_17,e_19,sum(e_11) as e_11 from t_equipment group by e_1,e_16,e_17,e_19) a full join (select f_1,f_12,f_13,f_15,sum(f_9) as f_9 from t_fee group by f_1,f_12,f_13,f_15) b on a.e_16 = b.f_12 order by e_16