ORA-00918: 未明确定义列

SELECT * FROM (SELECT TMP.*, ROWNUM ROW_ID FROM (SELECT T.ID, T.APPLY_PER, T.APPLY_STATUS, T.APPROVE_PER, T.APPROVE_TIME, T.TAKE_DOWN_PER, T.TAKE_DOWN_TIME, T.SEAL_PER, T.SEAL_TIME, U.REALNAME, AUS.REALNAME, TU.REALNAME, SU.REALNAME FROM SPV_VOUCHER_BORROW_APPLY T LEFT JOIN SYS_USER U ON T.APPLY_PER = U.ID LEFT JOIN SYS_USER AUS ON T.APPROVE_PER = AUS.ID LEFT JOIN SYS_USER TU ON T.APPROVE_PER = TU.ID LEFT JOIN SYS_USER SU ON T.APPROVE_PER = SU.ID ORDER BY T.APPLY_BEGIN_TIME DESC, T.ID ASC, T.ID ASC) TMP WHERE ROWNUM <= 10) WHERE ROW_ID > 0

这种SQL 容易出现未明确定义列的情况，因为3个realname，正确的做法应该是

SELECT * FROM (SELECT TMP.*, ROWNUM ROW_ID FROM (SELECT T.ID, T.APPLY_PER, T.APPLY_BEGIN_TIME, T.APPLY_STATUS, T.APPROVE_PER, T.APPROVE_TIME, T.TAKE_DOWN_PER, T.TAKE_DOWN_TIME, T.SEAL_PER, T.SEAL_TIME, U.REALNAME AS "U.realname", AUS.REALNAME AS "AUS.realname", TU.REALNAME AS "tu.realname", SU.REALNAME AS "su.realname" FROM SPV_VOUCHER_BORROW_APPLY T LEFT JOIN SYS_USER U ON T.APPLY_PER = U.ID LEFT JOIN SYS_USER AUS ON T.APPROVE_PER = AUS.ID LEFT JOIN SYS_USER TU ON T.APPROVE_PER = TU.ID LEFT JOIN SYS_USER SU ON T.APPROVE_PER = SU.ID ORDER BY T.APPLY_BEGIN_TIME DESC, T.ID ASC, T.ID ASC) TMP WHERE ROWNUM <= 10) WHERE ROW_ID > 0

给3个同名列定义不同名字