加上GROUP BY 就可以了
create or replace view V_ConInfo as
select A.ConCode, --合同编号
B.Material, --产品名称
SUM(B.UnitPrice*B.Numbers) ConSum 工--合同总金额
from T_ConInfo A,T_MaterialList B
where A.ConID=B.ConID
group by a.ConCode, b.Material
create or replace view V_ConInfo as
select A.ConCode, --合同编号
B.Material, --产品名称
SUM(B.UnitPrice*B.Numbers) ConSum 工--合同总金额
from T_ConInfo A,T_MaterialList B
where A.ConID=B.ConID
group by a.ConCode, b.Material
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货