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