Hi,

I have two related tables:

public class User {
private Long id;
String Code;
}

public class Leader {
Long id;
private User user;
...
}


Two things I'd like to do:

1. return a list of Users that are not in the Leader table;

session.createQuery("from User u where ( not in (select p.usr from Leader p))").list(); // this does not work


2. return a list of Code that belong to a user not in the Leader table;
session.createQuery("select u.code from Usr u where ( not in (select p.usr from Leader p))").list();

1.

2.

Rating is welcome. ;-)