Hello everybody,
I am using hibernate 2.1.
I have two classes UserDTO.java and EmployeeDTO.java.
Here relationship is employee has user.
EmployeeDTO contains an user object.
I want to execute following SQL:

SELECT em.id from employee
except
SELECT em.id from Employee em, User us WHERE em.id = us.employee

I mean I want to run except operation in HQL.
If not support in HQL, is there any alternative way in which i can run my sql in HQL format.
Regards
banik

select em.id from Employee em
where not exists (from User u where u.employee = em)

Hello Gavin,
Ya, it works. thank you so much. -:).
Regars Banik

No problem. Good luck!