I have two tables in SQL, one is users and the other is project_members. Users has lots of columns, but the only important column to this problem is the user_id column. project_members has two columns, pm_project and pm_user. Every project consists of a team of users, so if a user is on a project then there is an entry in the project_members table with pm_project as the project id and pm_user as the user_id. Selecting all the users on a project is pretty easy, I just use the statement:<BR><BR>select * from users inner join project_members on project_members.pm_user = users.user_id where project_members.pm_project='35'<BR><BR>w here 35 is a sample project id. I, however, want to select all of the users not on a project. I can not just use:<BR><BR>select * from users inner join project_members on project_members.pm_user <> users.user_id where project_members.pm_project='35'<BR><BR>b ecause every single user is returned multiple times (with users not on the project returned once more than users on the project). So how do I return all of the users not on the project?