I am able to run a query successfully with Oracle SQL developer, but when I enter the exact query into a text file which is read by a JAVA file it returns ORA-00918: column ambiguously. Any thoughts? Please let me know if any additional information is needed. There is a join in the query. It worked before I added the join and I have given the tables aliases.