SELECT
sinv_repmst.locsum as locsum,--------
sum(sinv_repmst.locsum) as sum,
ordermst.compno
FROM sinv_repmst,ordermst
WHERE sinv_repmst.compno='K1038-10' and ordermst.compno='K1038-10'
---数据太多,暂时我就看新增的这一条,可以忽略这条件,
GROUP BY sinv_repmst.locsum, sinv_repmst.compno,ordermst.compno
想要的结果是
根据compno ,相同则求和 想显示出locsum为 41707.7