try:
update A set projmoney =
(Select sum(Projmoney) from B where charindex(','+Projid +',' , ','+A.subProjid+',')>0)
update A set projmoney =
(Select sum(Projmoney) from B where charindex(','+Projid +',' , ','+A.subProjid+',')>0)
你好 .很感谢你的支持.可是我现在A表里没有哪个projmoney字段.怎么办?