insert into Resume(userId,userName,companyId,link,gender,birthday,dutyLevel,deptId,deptName,stationId,stationName)
Select
a.userId as userId ,
a.firstName+a.lastName as userName,
a.companyId as companyId,
a.emailAddress,
e.male as gender,
e.birthday as birthday,
e.securityLevel as dutyLevel,
org.organizationId as deptId,
org.name as deptName,
St.Soid As Stationid,
St.Stationname As Stationname from
User_ as a
inner join
Contact_ as e
on
e.contactId = a.contactId
left join
StationOrg as st
on
e.prefixid = st.soId
left join
Users_Orgs as uorg
on
uorg.userId = a.userId
left join
Organization_ as org
on
org.organizationId=uorg.organizationId
where
a.userId <>2
and
a.userId <>5
解决方案 »
- 求解
- 急救:小弟问个有关于ORACLE中FUNCTION的问题,希望懂的人都进来指点下
- 急!!快照不能刷新问题。
- 一个很难的问题:A电脑怎么访问到B电脑上的ODBC数据源
- 奇怪,我执行了update之后然后执行commit怎么没有效果?
- 严重告急,redo01.log,redo2.log,redo3.log误删!如何恢复!
- 对rowid的操作为什么会这么慢?
- 没用过oricle,不知道如何才能把我的数据库备份文件恢复回去?问题很菜,不过我决不吝啬我那点靠每天登陆得来'积蓄'.
- 急!!!求一sql语句!请大侠帮忙!
- 怪问题!!!那位兄台遇到过,帮帮我吧!!!!
- oracle登入问题
- 求高手优化这条sql语句
表名的别名,:SQL用AS,ORACLE 空格即可