[jboss-user] [EJB 3.0] - Re: A classic EJB Left Join and Order By clause problem

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#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...