I am using JBoss 3.2.2 and MySQL 4.0.18 I I run this query SELECT OBJECT(o) from Table o WHERE o.blah.id = ?1 ORDER BY o.meef.foo.id
It does not seem to joint correctly and generates a full cartesian product of the tables. However, if I do: SELECT OBJECT(o) from Table o WHERE o.blah.id = ?1 AND o.meef.ORDER BY o.meef.foo.id The query runs normally and returns the expected results. Has anyone else seen this behavior and if sho what have they done about it? Thanks, Jake T. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3829783#3829783 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3829783 ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
