总的折算金额 = zs_je * rc ???select a.sjlx,zs_je*sum(rc)
from a left join b on a.sjlx = b.sjlx
group by a.sjlx所有sjlx的总合select sum(zs_je*sum(rc))
from a left join b on a.sjlx = b.sjlx
group by a.sjlx
from a left join b on a.sjlx = b.sjlx
group by a.sjlx所有sjlx的总合select sum(zs_je*sum(rc))
from a left join b on a.sjlx = b.sjlx
group by a.sjlx
from A,B
WHERE A.sjlx = B.sjlx