query to tell if a number in one table is in another

Alright I have a users table the only field I need to worry about is ID

and a clearence table the only field I need to worry about is userID

What is the sql syntax to determine basically

"what ID's from the users table do not have a record in the clearence table"?

SELECT uid FROM users WHERE uid NOT IN (SELECT id FROM clearance);

Although, after looking at MySQL's documentation, the MySQL version would look like

SELECT uid FROM users WHERE uid <> ANY (SELECT id FROM clearance);

cool man thanks

No dice - get error 1064 you have an error near (SELECT ID FROM clearence)

NP 🙂