MySQL - query All users WITHOUT assignment

Question

If I have two tables: "Users and Appointments". How would I query the db to find something like the following:

SELECT * FROM users WHERE (none of: appointments.user = user.id)

I'm guessing I'll need some type of meeting table join, just not sure where to start.

+2

kilrizzy 09 oct. 09 at 18:44

2 answers

Try the following:

SELECT * FROM users WHERE users.id NOT IN (SELECT user FROM appointments)

+5

Martin B 09 oct. 09 at 18:46

JohnFx · Accepted Answer · 2009-10-09T18:46:59+0000

SELECT * FROM users 
LEFT JOIN Appointments ON Users.UserID=Appointments.UserID
WHERE Appointments.UserID is null