Hi guys,

I have an SQL query which I need to translate to Hibernate:

SELECT * FROM LeaseCars
JOIN Contract ON Contract.LeaseCarID = LeaseCars.LeaseCarID
WHERE Contract.ContractStatus = HISTORY;

Already got this piece of Hibernate code to work:

public List<Car> getUnusedCars()
{
return baseDAO.getCarsByCriteria(Restrictions.eq("carStatus",
"0"), Restrictions.eq("brand", "Subaru"));
}

This uses one table, so I'm stuck on joining multiple tables in one query. Anyone knows how to do this? I am completely new to Hibernate so please go easy on me :)

Have you defined associations between the tables in hbm files? Once you have done that you can create aliases to the relevant tables using criteria object and it will do the joins for you.