How to write hibenrate Query for extracting column values from TWO TABLES???

Hibernate version: 3.0

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using: MSSQL Server 2000

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

With Hibernate, it helps to not think of tables, but objects. What type of query do you want to perform? Can you give us an example? What fields do you want from what classes and how are the classes assocated (if at all)?

Hello Firend:

You can use Criteria in hibernate, which allows you set diferent diferents values vof any objects attributes .

When you get recover a Object from a Criteria, you can recover a object attribute of that object. So you can see and manipule the object inside.

Request for Comments.

Regards.

http://www.javalobby.org/articles/hibernate-query-101
Has some examples of what I think you are trying to do.. I found this to be an excellent article. I am new to hibernate but this article shows several methods for accessing multiple object (tables if you will). Also for a good article on different ways to map object you could look at
http://www-128.ibm.com/developerworks/java/library/j-hibernate/

I hope that this give you some help...

say you would not happen to have any good articles on joins would you?? ah just thought that I would ask.. That is what I am having trouble understanding..

if this is some help.. I could use a point.. if it is of help.. If not let me (us) know and I will take another shot..