mysql equiv. of Oracle not in

[sutter]

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?

[[deleted]]

This has nothing to do with 'NOT IN'. MySQL also understands NOT IN, but mysql does not do subqueries.

You'll have to use two queries, one to get a list of approved users, and one to select the user_id WHERE user_id NOT IN(list_of_ids_from_first_query)