Compare 2 List Of User Ids From Different Tables

[sonesay 7]

Hi all. I am trying to make a list out of 2 list. The first list is a complete list of users id from users table (List A) The Second list is of users id from another table (List :PI want to subtrack the user ids in List B from List A and make List C.Thanks in advance for any help :)Update: I looked up a old sql book i had and found some query examples. I tried the EXCEPT statement in mysql but it dont work so used another example.

SELECT userid, usernameFROM usersWHERE userid NOT IN (SELECT ea_user_idFROM events_attend)

Good thing Mysql can do it I was dreading the idea of having to do this in php arrays.

Edited October 11, 2007 by sonesay (see edit history)

[Stenno 0]

Your code is fine, but you could also do it this way:

SELECT * FROM `users`,  `events_attend` WHERE users.userid != events_attend.ea_user_id

I guess this has the same output