征求一个SQL语句

[123bug]

有两个表
一个是会员资料
一个是会员积分明细

会员资料表里面有
卡号、姓名、会员积分
KAHAO、XINGMING、HYJF
会员积分表
卡号、会员消费积分
KAHAO，HYXFJF

要求把会员积分表里面的HYXFJF汇总的值，填加到会员资料表里面

[wgsasd311]

update [会员资料表] set [会员积分]=[会员积分]+b.sum(会员消费积分)
from [会员资料表] a,[会员积分表] b where a.[卡号]=b.[卡号]

[子陌红尘]

update
a
set
HYJF = (select isnull(sum(HYXFJF),0) from 会员积分表 where KAHAO=a.KAHAO)
from
会员资料表 a

[jzdmyjzd]

Select A.KAHAO,A.XINGMIN,A.HYJF,B.HYXFJF
From 会员资料 A
Left Join (Select KAHAO,Sum(HYXFJF) As HYXFJF From 会员积分表
Group By KAHAO ) B
On A.KAHAO = B.KAHAO

[子陌红尘]

如果需要保留会员资料表中原有的会员积分:
---------------------------------------------------------------------
update
a
set
HYJF = isnull(a.HYJF,0)
+ (select isnull(sum(HYXFJF),0) from 会员积分表 where KAHAO=a.KAHAO)
from
会员资料表 a

[jzdmyjzd]

我刚才理解错了, 同意libin_ftsafe(子陌红尘) 的方法

[lisiyong]

Select A.KAHAO,A.XINGMIN,A.HYJF,sum(B.HYXFJF)
From 会员资料 A ,会员积分 B
Left Join B
On A.KAHAO = B.KAHAO

[wgsasd311]

把下面代码字段替换为你设置　的字段　即可：
update [会员资料表] set [会员积分]=[会员积分]+sum(b.[会员消费积分])
from [会员资料表] a,[会员积分表] b where a.[卡号]=b.[卡号]

[zhangyang555]

update a set HYJF = (select isnull(sum(HYXFJF),0) from 会员积分表 where KAHAO=a.KAHAO)
from 会员资料表 a