高手帮忙，在线等待。关于inner join

ghost007

我想问问在oracle817中支持inner join 么?
我得程序在oracle9i下运行正常，在oracle817中就不行，提示以下的sql语句
不正确：SELECT RO_SYSTEM.SYSID,RO_SYSTEM.UUID,RO_SYSTEM.SYSNAME,RO_SYSTEM.SYSDESC,RO_SYSTEM.CREATETIME,RO_SYSTEM.guestenable FROM RO_SYSTEM Where RO_SYSTEM.SYSID<>;0 AND RO_SYSTEM.SYSID in(  SELECT RO_APPLICATION.SYSID FROM RO_APPMODULE, RO_APPLICATION WHERE RO_APPLICATION.APPID = RO_APPMODULE.APPID AND RO_APPMODULE.MODULEID IN( SELECT DISTINCT RO_MODULE.MODULEID  FROM RO_MODULE INNER JOIN RO_APPMODULE ON RO_MODULE.MODULEID = RO_APPMODULE.MODULEID INNER JOIN RO_APPlication ON RO_APPMODULE.APPID = RO_APPlication.Appid WHERE RO_MODULE.ENABLED = 1 AND RO_MODULE.ADMINFLAG = 0 AND RO_APPMODULE.ENABLED = 1 AND ( RO_Module.NeedRight=0 OR (RO_MODULE.NEEDRIGHT = 1 AND RO_MODULE.MODULEID IN(  (SELECT DISTINCT RO_MODULERIGHT.MODULEID FROM RO_MODULERIGHT,RO_ROLERIGHT WHERE RO_ROLERIGHT.RIGHTID = RO_MODULERIGHT.RIGHTID  AND RO_MODULERIGHT.RIGHTID NOT IN (SELECT RO_MODULERIGHT.RIGHTID FROM RO_MODULERIGHT,RO_RIGHTDISABLE WHERE RO_RIGHTDISABLE.RIGHTID = RO_MODULERIGHT.RIGHTID AND RO_RIGHTDISABLE.PERSONID = 4)  AND RO_ROLERIGHT.ROLEID IN (  (SELECT RO_ORGROLE.ROLEID FROM RO_ORGPERSON,RO_ORGROLE,RO_ROLE WHERE RO_ORGROLE.ORGID = RO_ORGPERSON.ORGID AND RO_ROLE.ROLEID = RO_ORGROLE.ROLEID AND RO_ORGPERSON.PERSONID = 4)  union (SELECT RO_GRPROLE.ROLEID FROM RO_GRPUSER, RO_GRPROLE, RO_ROLE WHERE RO_GRPROLE.GRPID = RO_GRPUSER.GRPID AND RO_ROLE.ROLEID = RO_GRPROLE.ROLEID AND RO_GRPUSER.PERSONID = 4)  union (SELECT RO_PERSONROLE.ROLEID FROM RO_PERSONROLE,RO_ROLE WHERE RO_ROLE.ROLEID = RO_PERSONROLE.ROLEID AND RO_PERSONROLE.PERSONID = 4)  )) ))) ) )
我想可能是oracle817中不支持inner join关键字吧。
高手帮忙，谢谢了

ghost007

谢谢了