SELECT * FROM Order WHERE OrderID IN (
SELECT DISTINCT ORderID FROM OrderDetail WHERE OrderDetailStatusID IN (1,2,3,4,5))
AND Order.VendorID=1 AND Order.SalesDate>'01.02.2004'

hi,
how can i write the hql replacement of above query?

thanx a lot.

what a helpful community!

Why don't you just try it yourself, tell us what you came up with, and what was the problem?

i can understand what you say.
but i have no experience with hql queries with joins.

thank you.

It may depend on how your tables are related, and whether that relationship is reflected as an association in your object mappings.

Assuming the Order object has a collection of OrderDetail objects, this might work (or might not):



I've never had much luck with dates as strings in HQL, so I would use a named parameter ":dateVal" in creating an IQuery, then set the parameter using a DateTime object.

The names of the objects and properties I used were arbitrary, and would depend on the mapping files matching the object to the table.

your message so illuminated my way.

thanks a lot.