join query through id without mapping.

[ambar patil]

Can I join one object through another by id where mapping form one object to another does not exist.
For example :

class A{
int b_id;
}

class B{
int id;
}
select myA from A as myA inner join B as myB where myB.id = myA.b_id;
it is not working I am gettting :
java.lang.NullPointerException
at org.hibernate.hql.ast.HqlSqlWalker.createFromJoinElement

[Mark Spritzler]

You can always do this with an SQLQuery object instead of trying it in HQL.

SQLQuery query = session.createSQLQuery("blahblah");

Something like that.

Mark

[Mathias Nilsson]

This is called a Theta-style joins. If you don't use inner join it should work

select myA from A as myA, B as myB where myB.id = myA.b_id;

// Mathias
[ August 13, 2007: Message edited by: Mathias Nilsson ]