[Hibernate-issues] Hibernate QL: Inner Joins

[William R. L. <wr...@ex...>]

All,

I'm trying to do an inner join within Hibernate, but I'm having some
difficulties and am hoping there's some knowledgeable people on the list.

I have two objects: a Session object and an Account object, which can be 
joined in a query with session.field = account.field4; however, I don't 
have any mappings defined in the Hibernate .hbm.xml files to this effect.

	Table Structure, session.field1 = account.field4:

	  Session       Account
	  -------       -------
	  id            id
	  field1  <-|   field3
	  field2    |-> field4

Even though I don't have the mappings defined between objects in the 
Hibernate configuration files (for reasons I won't go into), I want to do 
an inner join and return objects of type Session only if account.field3 
equals a particular value.  In SQL, I could do this using something like:

	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 + "' ";

Can someone point me in the right direction?  Thanks, in advance.

--          _ 
__ __ ___ _| | William R. Lorenz <wr...@ex...> 
\ V  V / '_| | http://www.clevelandlug.net/ ; "Every revolution was 
 \./\./|_| |_| first a thought in one man's mind." - Ralph Waldo Emerson