Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.0

I have the following tables:
--------
Vendor
--------
-id
-name
-city
...
...

Model class has
----------------------
Vendor.java
----------------------
-get/setID
-get/SetName
-get/SetCity
-hasHistroy()
-setHistory()

--------
History
--------
-id
-vendorId
-fileName
-initialVal
-changedVal


Model class has
--------------------
History.java
--------------------
get/setID()
get/setVendorID()
...
...



I need HQL query that gives in me a list of Vendors and also populate the vendor hasHistory() field based on "does vendor have atleast one column in the History table.

Can anybody sugget how the query should look like.

Thanks,
Malini Kesavan