两个select from语句怎么合并

推荐回答

select * from (select unit,count(*)as number from archives_management group by unit) Ainner join (select fine_units,count(*) as fine_number from fine group by fine_units) Bon A.unit=B.fine_units