Hi all,

i am trying to do that in HQL :

SELECT c.customer_id
FROM customer as c
WHERE c.customer_id NOT IN (5, 6, 9)

Thanks all

----
Sebastien

First of all is this a report query and not expected to return objects? I would just use JDBC if so.

If you want to get the customer objects, (and I know its not the preferred method of the proud inventors of HQL), but I like the native SQL query API. e.g.

select {c.*} from customer c where c.customer_id not in (5,6,9)
"c"
Customer.class

http://www.hibernate.org/hib_docs/refer ... -nativesql