22,209
社区成员
发帖
与我相关
我的任务
分享
update t3
set t3.jf=t4.jf,t3.dj=t4.dj
from (select a.userid,a.username,b.jf,b.dj from t1 a left join t2 b on a.username=b.username) as t4
where t3.userid=t4.userid
写个简单的,暂时不考虑重复项
select a.username,b.jf,b.dj
from t1 a,t3 b
where a.userid=b.userid
话说更新jf dj是什么意思。