update ps13 set dfsl=t.sl
from ps13,(select cppz,cpgg,package,sum(sl) as sl from ps12 group by cppz,cpgg,package) as t
where ps13.cppz=t.cppz and ps13.cpgg=t.cpgg and (t.package like rtrim(pzhm)+ '% ')
请问有什么问题?
现在运行只会部分记录数据加到PS13中,是不是t.package like rtrim(pzhm)+ '% '不能这样写?
------解决方案--------------------
where ps13.cppz=t.cppz and ps13.cpgg=t.cpgg
and t.package like pzhm+ '% '
------解决方案--------------------
t别名表t.package是以ps13表的pzhm列开头的作为条件