Hi,

I would like to have a query like this:

SELECT t1.*
FROM Table1 t1, Table t2
WHERE t1.column = t2.column

The result is stored in a list. I want to have "Table1" objects in this list.

Question:
- Do I automatically get "Table1" objects in my list, or do I have to cast them first (and how)?
- How would the HQL look like? The same?

Thanks
Jonny



Hibernate version: 3.0.2

Try it yourself.

SELECT t1 FROM Table1 t1, Table t2 WHERE t1.column = t2.column

If there was a relationship defined in the mapping (which is much better).

SELECT t1 FROM Table1 t1 join t1.table2

The alias in the select clause defines what is returned in the list, eg, the complete table1 objects

As always its best to have a play and see what you get. The hibernate console is a great tool for doing adhock queries. Give it a try.