我想用query做一个右连接，连接oracle的2个表，这样为什么不行？(100分)

SELECT Makeup_test.EXA_NO, Makeup_test.COU_NO, Makeup_test.TERM, Makeup_test.GRADE, Makeup_test.ZERO_REASON, Makeup_test.MAK_FIR_NUM, Makeup_test.FIR_ZERO_REASON, Makeup_test.MAK_SEC_NUM, Makeup_test.SEC_ZERO_REASON, Makeup_test.MEMO, Achview.ACH_CRE, Achview.ACH_NUM, Achview.CLASS_LIST, Achview.COURSE_NO, Achview.GRADE, Achview.GRADE_LIST, Achview.TERM, Achview.CLASS_NO, Achview.GENDER, Achview.ORG_NO, Achview.SPECILITY_NO, Achview.STU_NAME, Achview.STU_NO
FROM ACHVIEW Achview RIGHT OUTER JOIN MAKEUP_TEST Makeup_test USING ( EXA_NO)

提示：general SQL error
ora_25154:using子句的列不能有限定词。

oralce里不是这样写

正确写法：
select * from table1 a,table2 b
where a.id=b.id(+)
~~~~~~

通过使用"(+)"来实现外连接

换成这样行不行：
FROM ACHVIEW Achview RIGHT OUTER JOIN MAKEUP_TEST Makeup_test
ON Achview.EXA_NO = Makeup_test.EXA_NO

backlove:
Oracle9i已经支持这种标准写法了。而且oracle建议你使用标准写法。