SQL如何使两个select语句查询结果合并一个？

Question

查询语句1
select unit,count(*)as number from archives_management group by unit
查询语句2
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
...... ....... ......
求大神解决

Answer 1

这样，你把第一个和第二个select写到一个新select查询的from里面，用join连接使公司名字相等，在新的select中投影出公司名和两个count

Answer 2

select * from

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

inner join

(select fine_units,count(*) as fine_number from fine group by fine_units) B
on A.unit=B.fine_units