oracle数据库查询问题

错误详细信息：org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from ( SELECT eu.*, (SELECT bu.duserid FROM wps_bind_user bu WHERE bu.userid=eu.userid AND bu.dappcode='MHXT') duserid, (SELECT LOGINNAME FROM uap_user u where u.userid=eu.userid) LOGINNAME, FROM wps_exch_user eu WHERE eu.valid='1' AND eu.userid not in (SELECT su.userid from wps_sync_user su) ) where rownum <= ?]; nested exception is java.sql.SQLException: ORA-00936: 缺少表达式

LOGINNAME, 这里多了个逗号

select * from
( SELECT eu.*,
(SELECT bu.duserid FROM wps_bind_user bu WHERE bu.userid=eu.userid AND bu.dappcode='MHXT') duserid,
(SELECT LOGINNAME FROM uap_user u where u.userid=eu.userid) LOGINNAME
FROM wps_exch_user eu WHERE eu.valid='1' AND eu.userid not in (SELECT su.userid from wps_sync_user su)
) where rownum <= ?

多表关联查询优化可以参考：
MySQL如何优化嵌套Join http://www.data.5helpyou.com/article272.html