ORACLE左连接怎么报“命令未正常结束呀”？？在线等，各位，谢谢
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

------解决方案--------------------
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
------解决方案--------------------
按照楼上的方法
------解决方案--------------------
左,右,全连接不是用where ,是用on