oracle查询表名标识符过长,多表连接，数据字段取别名，标识符过长，查询报错问题...

SELECT TMP_PAGE.*, ROWNUM ROW_ID

FROM ( SELECT a.userid AS "userid",

a.companyid AS "companyid",

a.loginname AS "loginname",

a.password AS "password",

a.truename AS "truename",

a.gender AS "gender",

a.brithdate AS "brithdate",

a.duty AS "duty",

a.mobile AS "mobile",

a.tel AS "tel",

a.email AS "email",

a.idcard_type AS "idcardType",

a.idnumber AS "idnumber",

a.usertype AS "usertype",

a.registerdate AS "registerdate",

a.verifystatus AS "verifystatus",

b.homepage AS "registerCompany.homepage",

b.address AS "registerCompany.address",

b.zip AS "registerCompany.zip",

b.attr AS "registerCompany.attr",

** b.companycodetype AS "registerCompany.companycodetype",

** b.companycode AS "registerCompany.companycode",

b.establishdate AS "registerCompany.establishdate",

b.registerfund AS "registerCompany.registerfund",

b.tel AS "registerCompany.tel"

FROM tregisteruser a

LEFT JOIN tregistercompany b ON a.companyid = b.companyid

ORDER BY a.userid DESC) TMP_PAGE

WHERE ROWNUM <= 20