mysql equiv. of Oracle not in

admin

Administrator
Staff member
I am trying to do a select of all values not already in a certain table. In oracle I would do something like:
select user_id from users where user_id not in (select user_id from approved_users)

Does anyone know a MYSQL equivalent?
 
Back
Top