anonymous wrote : | Well I found the solution to my problem by updating to Oracle to 10g since any version below 10g does not support the ORDER BY column that is not a part of the SELECT statement.
I'm not sure what you're error msg said but I don't believe this was the problem. I just tried SELECT columnA FROM tableA order by columnB and it works flawlessly. Of course, it does! Regards fhh View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3972576#3972576 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3972576 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
