Question

SQL语句写出来的一张表，怎么把物料代码的那一行相同的物料，存货数量相加，怎么写？

Answer 1

SELECT t2.fnumber as '料号',count(*) as ‘存货数量’
FROM icinventory t1,t_icitem t2
where 你的条件...
group by t2.fnumber

Answer 2

SELECT SUM(FQty) as ‘存货数量’, fnumber as '料号'
FROM t1
group by fnumber

Answer 3

select t2.fnumber , sum(t1.fqty) from icinventory t1
inner join t_icitem t2
on t1.fitemid = t2.fitemid
where t1.fqty <> 0
order ...
后面的语句自己补上吧