SQL问题 ( 积分: 50 )

select id=max(id),partno,partname,zpaper,innum=sum(number),units,
part=case when zpaper='无标签'then
rtrim(ltrim(partno))+'→'+rtrim(ltrim(partname))
else
rtrim(ltrim(partno))+'→'+rtrim(ltrim(partname))+char(47)+rtrim(zpaper)end,
numberunit=rtrim(ltrim(str(sum(number))))+space(1)+ltrim(rtrim(units))
from cSendInfo材
......
不能重复partno,但partname有同的记录,该怎样不重复partno?
而且number只跟据partno求总和.

select id=max(id),partno,partname,zpaper,innum=sum(number),units,
part=case when zpaper='无标签'then
rtrim(ltrim(partno))+'→'+rtrim(ltrim(partname))
else
rtrim(ltrim(partno))+'→'+rtrim(ltrim(partname))+char(47)+rtrim(zpaper)end,
numberunit=rtrim(ltrim(str(sum(number))))+space(1)+ltrim(rtrim(units))
from cSendInfo材
......
不能重复partno,但partname有同的记录,该怎样不重复partno?
而且number只跟据partno求总和.