日期:2014-05-17  浏览次数:20756 次

sql server中多重连接在oracle中怎么写
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 

把这个sql server中的语句改成oracle版本的 该怎么写

------解决方案--------------------
把表的别名前的AS去掉,

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_ a
INNER JOIN Contact_ e
ON e.contactId = a.contactId
LEFT JOIN StationOrg st
ON e.prefixid = st.soId
LEFT JOIN Users_Orgs uorg
ON uorg.userId = a.userId
LEFT JOIN Organization_ org
ON org.organizationId=uorg.organizationId
WHERE a.userId <>2
AND a.userId <>5