I am working with Oracle 8.1.7 on Tomcat 4.0 (Apache). Here is my SQL taken from my JSP:
The query works fine and gives the desired results in PL/SQL Developer. Yet when I take it into my JSP I get the following error: java.sql.SQLException: Invalid column name I've tried placing it in a PreparedStatement as well as a regular Statement. Both give me the same error. I've tried using all different combinations of aliases on my tables and columns but am getting the same error every time. Anyone out there have an idea for me?