是不是这样:
select a.code,a.tc*b.rate from (select code,sum(1) as tc from t1 group by t1) a join d1 b on a.code=b.code
select a.code,a.tc*b.rate from (select code,sum(1) as tc from t1 group by t1) a join d1 b on a.code=b.code
调试欢乐多
group by code2.select sum(a.type*b.rate) from T1 a inner join D1 b on a.code=b.code