目标:根据compno ,相同则求和 想显示出locsum为 41707.7

上图是查询结果
下图是语句
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
实际情况还有许多复杂条件