表结构设置成这样不太好
建一个LICENSE_ID_MT GROUP_DES_MT 的表 来关联第二个表
select b.GROUP_DES_MT, sum(a.EVENT_NUM_MT) from scheme a,select distinct LICENSE_ID_MT ,GROUP_DES_MT from Group_mt) b where a.LICENSE_ID_SC= b.LICENSE_ID_SC
group by a.LICENSE_ID_SC
就可以了吧
select a.LICENSE_ID_MT, b.GROUP_DES_MT,sum( a.EVENTS_NUM_SC)
from scheme a,
(select distinct LICENSE_ID_MT ,GROUP_DES_MT from Group_mt) b
where
a.LICENSE_ID_SC= b.LICENSE_ID_SC
group by
a.LICENSE_ID_MT,b.GROUP_DES_MT