Christian, Does that mean that I can use HQL to join tables unless there's a mapping that will allow that join to happen implicitly? If I can in fact join them explicity, could you please provide me a bit of syntax example?
Thanks for your quick response, Christian! On Fri, 17 Oct 2003, Christian Bauer wrote: > > SELECT * FROM session > > LEFT JOIN account ON Session.field1 = account.field4 > > WHERE account.field3 = 'value' > > However, I can't seem to get Hibernate to perform this kind of > > functionality. This is what I'm using as a Hibernate Query right now: > > String query = > > "FROM session IN CLASS org.express.test.Session " + > > "WHERE field1 = '" + field1 + "' "; > Thats correct. HQL joins on an implicit join condition (the association > mapping) and not on an explicit join condition. For an inner join, you > can of course use theta style, like you did. -- _ __ __ ___ _| | William R. Lorenz <[EMAIL PROTECTED]> \ V V / '_| | http://www.clevelandlug.net/ ; "Every revolution was \./\./|_| |_| first a thought in one man's mind." - Ralph Waldo Emerson ------------------------------------------------------- This SF.net email sponsored by: Enterprise Linux Forum Conference & Expo The Event For Linux Datacenter Solutions & Strategies in The Enterprise Linux in the Boardroom; in the Front Office; & in the Server Room http://www.enterpriselinuxforum.com _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
