left outer join 格式问题

[marklr]

select a.theMisid,de.missionName from theLockMis as a left outer join select * from missionArrange as de on a.theMisid=de.id


提示 select 附近语法错误

[aF_Magic]

select a.theMisid,de.missionName from theLockMis as a 
  left outer join missionArrange as de
   on a.theMisid=de.id

[Mr_Nice]

select a.theMisid,de.missionName 
from theLockMis as a 
left outer join (select * from missionArrange) de 
on a.theMisid=de.id 

[黄_瓜]

select a.theMisid,de.missionName from theLockMis as a
left outer join
(select * from missionArrange )as de
on a.theMisid=de.id

[百年树人]

select a.theMisid,de.missionName 
from theLockMis as a 
left outer join missionArrange as de 
on a.theMisid=de.id 

[npkaida]

select a.theMisid,de.missionName from theLockMis as a left outer join missionArrange as de on a.theMisid=de.id 

[yuangang1011]

select a.theMisid,de.missionName from theLockMis as a left outer join (select * from missionArrange) as de on a.theMisid=de.id 

加括号试一下

[易十五]

select a.theMisid,de.missionName from 
theLockMis as a left outer join 
(select * from missionArrange) as de on a.theMisid=de.id