Hi, i'm a HQL newbie...i got 2 tables Player and Manager(Many to 1 relationship)..the SQL equivalent is below..

SELECT *
FROM Player ply INNER JOIN
Holiday hol ON ply.holidayid = hol.id
WHERE (ply.club LIKE 'AC Milan') AND (hol.date like '20050622')

means i want to get the list of players where they play for AC Milan and went for a holiday on 2005/06/22 date.

how do i convert it to a HQL query...i tried..the following

"from Player ply where ply.club like :club and ply.holidayid like (select id from Holiday hol where hol.date like :holDate)"

didn't work

Oops..i solved..ignore the post