I'm having a bit of trouble

[Anon]

I couldn't really explain it in the title.

Basically, this is the database design:

table users(id int(4) auto_increment, fname varchar(15), lname varchar(15), email varchar(35), primary key(id));

table projects(description text, id int(4) auto_increment, primary key(id));

table users_in_projects(userid int(4), projectid int(4));

You will be able to add a user to a project with a form. My problem is that I can't figure out a way to select the users that are currently NOT in the project to build a list to allow the administrator to add them. If this seems confusing, here's some sample data:

In users:

fname - joe
id - 1
fname - jim
id - 2
fname - jill
id - 3

projects:
description - build a house
projectid - 1

users_in_projects:

userid - 3
projectid - 1

So, jill is in project one. What I want the query to select is their fname if they are NOT in project 1.

Thank you,
I'm sure this makes no sense

[nostradamus]

to select the users that are currently NOT in the project :

select users.fname from users where users.id is not in (select users_in_projects.userid from users_in_projects, projects where users_in_projects.projectid = projects.id)

That should work, greetings Nostr@damus.