I need to use a theta-style join for two objects that do not have their relationship mapped in the class mappings (in this post, I won't get into the reason why I need this). The book, Hibernate in Action, shows that Hibernate supports theta-style joins and I'm hoping that nHib does, too, but I'm getting an error: outer or full join must be followed by path expression

Here is the code:

IQuery q = _session.CreateQuery("select e from CEvent e inner join PhysicalNetworkDevice pnd WHERE e.NetworkElementID = pnd.ID AND e.NetworkElementTypeName = 'Device' AND e.ID = :id");

q.SetInt32("id", iID);
System.Collections.IList list = q.List();
cevent = (CEvent)list[0];

Anything I'm doing wrong?

Thanks,
Bill

metazone,

Theta-joins are those joins which are expressed exclusively in the WHERE clause.
Your query with theta joins would look:



in your example you were mixing normal and theta join syntaxes

Thanks very much -- this worked. I guess I'm a little confused with respect to the syntax for normal vs. theta-style joins

This solves problem only for inner join. What about outer join(left/right/full)?

I have a requirement to join two tables unrelated w.r.t. hibernate.
I want something like:

I want Object[] where Object[1] could be null when no links exist and viceversa.
I cant do this with HQL.