你需求描述的确实不是很清楚。你还不如直接列出两个表你需要的字段,以及关联的字段呢试试这个行不行:select mm.institution,nn.zwsl+b.bc from ( select sum(acceptNum) zwsl,institution from tbl_network n,ao_item a where a.id = n.itemId group by institution ) mm inner join ( select institution,count(*) bc from tbl_ywsl y where isbj = 1 group by institution ) nn on mm.institution=nn.institution
(
select sum(acceptNum) zwsl,institution from tbl_network n,ao_item a where a.id = n.itemId group by institution
) mm
inner join
(
select institution,count(*) bc from tbl_ywsl y where isbj = 1 group by institution
) nn
on mm.institution=nn.institution