17,090
社区成员
发帖
与我相关
我的任务
分享求SQL（oracle数据库）
两张表：用户表userlist（userid，username）
职工表infostaff（staffid，staffname）
更新职工表，条件是把username=staffname的staffid改为userid
职工表infostaff（staffid，staffname）
更新职工表，条件是把username=staffname的staffid改为userid
...全文
请发表友善的回复…
发表回复
CT_LXL 2014-02-21
- 打赏
- 举报
merge into infostaff t1 using userlist t2 on(t1.username=t2.staffname)
when matched then
update set t1.staffid=t2.useridmerge into infostaff t1 using userlist t2 on(t1.username=t2.staffname)
when matched then
update set t1.staffid=t2.useridCT_LXL 2014-02-21
- 打赏
- 举报
merge into infostaff t1 using on userlist t2 on(t1.username=t2.staffname)
when matched then
update set t1.staffid=t2.useriderge into infostaff t1 using userlist t2 on(t1.username=t2.staffname)when matched thenupdate set t1.staffid=t2.userid
Juedaifanghua 2014-02-21
- 打赏
- 举报
merge into infostaff t1 using on userlist t2 on(t1.username=t2.staffname)
when matched then
update set t1.staffid=t2.useridCT_LXL 2014-02-21
- 打赏
- 举报
merge into infostaff t1 using on userlist t2 on(t1.username=t2.staffname)
when matched then
update set t1.staffid=t2.userid
bloodwps 2014-02-21
- 打赏
- 举报
update tab1 a set id1=
(select id2 from tab2 b where a.nam1=b.name2);
前提是没有重名的，有重名的更新就不准了可以+个ronum=1
zjp5186 2014-02-21
- 打赏
- 举报
update infostaff set staffid =
(select userid from userlist where staffname = username)
