Something

my query is this:select * from (select distinct a.SERIAL_NUM, a.RFID, a.NOMENCLATURE, a.RACK from ASSET a, CADETS c, ASSIGNMENT b WHERE c.ALPHA = b.CADET_ALPHA and b.ASSET_SERIAL_NUM = a.SERIAL_NUM) where ROWNUM BETWEEN 1 and 20 ORDER BY SERIAL_NUMit causes:2005-11-29 14:04:48 StandardWrapperValve[jsp]: Servlet.service() for servlet jsp threw exceptionjava.sql.SQLException: Invalid column indexbut the query works just fine the way it is if I run it directly off of oracle.