HQL left join

indie_life · **Joined:** Wed May 02, 2007 6:37 am **Posts:** 6

Hi,

I am relatively new to HQL and I am having problems with converting an sql query to hql.

Code:

FROM    t1 AS t1       
LEFT JOIN t2 AS t2 ON t1.xxx = t2.yyy where .....

Any help would be great

Thanks

evdelst · **Joined:** Wed Aug 24, 2005 11:49 am **Posts:** 63

You just have to map the relation and then you can use:

Code:

from T1 left outer join t1.xxx as t2

indie_life · **Joined:** Wed May 02, 2007 6:37 am **Posts:** 6

so in my hbm mapping i need to declare a relationship between the tables only?

evdelst · **Joined:** Wed Aug 24, 2005 11:49 am **Posts:** 63

Something like this:

Code:

<class name="T1" table="t1">
    <id ...>
   <many-to-one name="xxx" class="T2">
</class>

<class name="T2" table="t2">
  <id name="yyy"/>
   ...
</class>

I recommend to read a little about mapping relations (in the reference docs)