Mapping:
Class A1 {
String ID;
}
Class B1 {
String ID;
}

HQL:
SELECT {a.*}, {b.*}
FROM A1 AS a, B1 AS b
WHERE a.ID = b.ID

How can I create a HQL equivalent of the above query?

I tried
DetachedCriteria criteria = DetachedCriteria.forEntityName("A1", "a");
DetachedCriteria subCriteria = criteria.createAlias("B1", "b");
subCriteria.add(Restrictions.eq("a.ID", "b.ID"));

but it gave me
org.springframework.orm.hibernate3.HibernateQueryException: could not resolve property: A1

Any suggestions?

Try the following:


List items = session.createCriteria(A1.class)
.setFetchMode(“B1”,FetchMode.JOIN)
.list();


call the setFetchMode() of the Criteria class with two parameters: the name of the class with which the current class has to be joined and mode of the fetching of the data from the associated class. (Hibernate: Criteria Queries in Depth, by A.P.Rajshakhar) See the following website for an example:

http://www.devarticles.com/c/a/Java/Hibernate-Criteria-Queries-in-Depth/2/

Oh I forgot to mention that they don't have any foreign key relationship, so it looks like this.

Mapping:
Class A1 {
long ID;
String text;
}
Class B1 {
long ID;
String text;
}

HQL:
SELECT {a.*}, {b.*}
FROM A1 AS a, B1 AS b
WHERE a.text = b.text

Anyone?