Demonic Posted June 12, 2009 Share Posted June 12, 2009 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 ) Link to comment https://forums.phpfreaks.com/topic/161999-solved-where-not-in-sub-select/ Share on other sites More sharing options...
Maq Posted June 13, 2009 Share Posted June 13, 2009 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. Link to comment https://forums.phpfreaks.com/topic/161999-solved-where-not-in-sub-select/#findComment-854892 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.