I'm currently evaluating Hibernate, so I'm quite new to this tool.
Could some one tell me how to do simple query like this:

select table1.attr1, table2.attr2 from table 1, table2 where ...

this kind of query is commonly used when you want to construct UI display with two or multiple tables by join them together.

I understand "join" is not a problem in Hibernate, inside the mapping file, there are classes mapped to table1 and table2, I can easily get all the attributes of table1 or table2, but how to get one attribute from table1 and one attribute from table2 like above example?

using "sub-class" concept is not appropriate for this case, since I don't want redundant data.

using "one to one" or "one to many" with collection is not appropriate also, since I have to resolve data inside the collection to my own data model (then using Hibernate become similar to use ResultSet)

any advice is highly appreciated!

Version: 2.1.2

use theta-style join

And read the reference guide

Thanks,
With your suggestion, by using session.createSQLQuery method, I got exact what I want!

You can use this with HQL, too. No need to do createSQLQuery