How to use NOT in or join in my problem ?

See more:

Java

Hibernate

I have a team and in that I have a team members ... In my other module if I want to add other members in my team then I select the department and it will show all the members of that department ... But the problem is I want to show only those members of that department who is not in that team ...In hibernate
Employee Table :

private Integer EId;
private Department department;
private String firstName;
private int number;
private String image;
private String emailId;
private Date dateOfBirth;


Teamdata Table :

private Integer no;
private EmployeeRegistration employeeRegistration;
private TeamMaster teamMaster;

What I have tried:

String str = "from EmployeeRegistration as emp where emp.EId NOT IN (from TeamData as team where team.teamMaster = '"+teamid+"' )";