Hello folks,

Query q1 = session.createQuery("select cust from Customer cust "
+ "join cust.orders custorder "
+ "join custorder.orderlines orderline "
+ "where orderline.product.price > 100.00");

this query returns a list of Customer instances. But the list contains multiple references to the same customer instances.
How is it possible to have unique instances (no duplicates) without re-wprking my result. Is there a kind of 'unique' keyword to add to my query ?

thanks for your help

Nicolas

distinct? This is just the same as with an SQL query.

too easy ... it just rocks !