Hibernate version:
2.1.6

Hi,

I read in an old forum post that Hibernate supports subqueries in the WHERE clause but not the SELECT clause. What about the FROM clause?

Something akin to this:

select item from PItem item, (select item from PItem item, PSubTable1 sub1 where ...) subQuery1 where item.field = subQuery1.field

I realize there are simpler forms of this query but am still interested in seeing if this case is possible.

Thank you,
BU

Addendum:

I tried a simple query like the one above and got:

QueryException: in expected: select [select item.....]