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

fhh do-not-reply at jboss.com
Tue Sep 19 09:42:25 EDT 2006


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



More information about the jboss-user mailing list