请教SQL查询语句问题

Question

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数据不对 要怎么修改呢？

Answer 1

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

Answer 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 还是要谢谢你~