I have following tables and corresponding classes with appropriate get/set methods for all fields.

ITEMS
ID

ORDER
ID
ITEM_ID
CUSTOMER_ID

class Item{
privater long id;
private Set orders;
...
}

class ORDER{
privater long id;
private Item item;
private long customer_id;
...
}


Could anyone suggest a HQL query that selects all items that have no orders for given customer_id?

SQL query for this looks like

SELECT ITEMS.* FROM ITEMS LEFT JOIN ORDERS ON ITEMS.ID=ORDERS.ITEM_ID AND (ORDERS.CUSTOMER_ID = ? ) WHERE (ORDERS.ITEM_ID IS NULL) ;

On thread is enough. Posting this stuff multiple times won't give you more answers.