I am just learning about Hibernate (I'm using NHibernate 1.0) and I have a question about HQL.

I have a valid SQL query that I run against my SQL server:



Assuming each of the tables (Table0, Table1 and Table2) have an associated hibernate-mapped class, what would the corresponding HQL query look like?

Thanks.

Assume that you have entities mapped to each table:

Entity0 -> Table0
Entity1 -> Table1
Entity2 -> Table2

and Entity0 contains properties:

Entity1 entity1
Entity2 entity2

Then I could write the HQL like:



I do the inner joins simply because I want to get everything in one SQL query (when the fetching is lazy), but I don't want to fetch other relations which Entity1 and Entity2 might contain.[/code]

Thanks! In this case my existing Entity0 does not contain objects of the other two types. The tables just have some loose relations based on the column values and i have to check to make sure the column values match up (see my SQL statement above) and only return those rows that are related to the other two tables in that specific way.

I think I can translate most of the SQL above to HQL but I don't know how to do thigs like "ON (t0.col1=t1.col1)"