Join Different tables using Criteria

Question

I have two different entities, I need to join them based on a common entity property between them, but there's no path to get from the entity the Criteria is created on to the other one! Please help.

Thanks

---

--Edit--

Sorry, maybe my question was not clear.

I have the following Entities:

class A
{
    string Text {get;set;}
}
class B 
{
    string Text {get;set;}
}
class C
{
    string Text {get;set;}
    B B_Object_1 {get;set;}
}
class D
{
    A A_Object {get;set;}
    B B_Object_2 {get;set;}
}

what I'm trying to do is creating a criteria on D entity, yet, I need to join it with C entity , and the join condition is D.B_Object_2 == C.B_Object_1

because on projection, or what I need to be selected as a results contains: D.A_Object.Text and C.B_Object_1.Text based on my join condition above.

Can this be done using Criteria or with the assistance of DetachedCriteria?

Thanks

Answer 1

I guess it's not possible. At least did not find any neat solution. But there are two workarounds:

1. Query only properties. Not sure Criteria API could handle this, but HQL defenitely does.
2. Plain old SQL-queries - session.CreateSQLQuery().