[SOLVED] WHERE NOT IN Sub Select?

[Demonic]

Will this work, I've never used a subselect before:

 

SELECT * FROM
users
WHERE
user_id
NOT IN 
( SELECT user_id FROM groups WHERE group_id = 1 )

[Maq]

Will this work, I've never used a subselect before:

 

SELECT * FROM
users
WHERE
user_id
NOT IN 
( SELECT user_id FROM groups WHERE group_id = 1 )

 

It's always good to try/test things out before asking questions.