ORACLE左连接怎么报“命令未正常结束呀”？？在线等，各位，谢谢

Question

select A.ArticleID,A.SpecialID,S.SpecialName,A.Title,A.Keyword,A.Author,A.CopyFrom,A.UpdateTime,A.Editor,A.Hits,A.OnTop,A.Hot,A.Elite,A.Passed,A.IncludePic,A.Stars,A.PaginationType,A.ReadLevel,A.ReadPoint From Cl_Article A left join Cl_Special S on A.SpecialID=S.SpecialID where A.Deleted=0 and A.SpecialID<>0 order by A.articleid desc

Answer 1

select A.ArticleID,A.SpecialID,S.SpecialName,A.Title,A.Keyword,A.Author,A.CopyFrom,A.UpdateTime,A.Editor,A.Hits,A.OnTop,A.Hot,A.Elite,A.Passed,A.IncludePic,A.Stars,A.PaginationType,A.ReadLevel,A.ReadPoint 
from Cl_Article A, Cl_Special S
where A.SpecialID(+) = S.SpecialID and  A.Deleted=0 and A.SpecialID<>0 
order by A.articleid desc

Answer 2

左,右,全连接不是用where ,是用on