请教SQL查询语句问题

[oppa8599]

select id,username,phone,t_user,u_money,xf,Alljf,addtime,faned,QQID from [user]
我想把字段Alljf 换成 select sum(d_getjf) from [dingdan]
条件 user.id = dingdan.userid

拼接后：select id,username,phone,t_user,u_money,xf,(select sum(d_getjf) from [dingdan] where userid = id)as Alljf,addtime,faned,QQID from [user]

查询结果Alljf数据不对 要怎么修改呢？

[發糞塗牆]

select id,username,phone,t_user,u_money,xf,b.d_getjf ,addtime,faned,QQID 
from [user] a inner join (
select userid, sum(d_getjf) d_getjf from [dingdan]) b
on user.id = b.userid

[oppa8599]

好了，select id,username,phone,t_user,u_money,xf,(select isnull(sum(d_getjf ),0) from [dingdan] where userid = b.id )as Alljf,addtime,faned,QQID from [user] b

还是要谢谢你~

[以学习为目的]

[Quote=引用 2 楼 的回复:]

好了，select id,username,phone,t_user,u_money,xf,(select isnull(sum(d_getjf ),0) from [dingdan] where userid = b.id )as Alljf,addtime,faned,QQID from [user] b

还是要谢谢你~
[/Quote]自己发现问题了，恭喜