I have 2 tables: Users and Log
I want to select ALL users from Users who are not in Log having already received a msg_id matching 'x'
What I have so far is this:
SELECT * FROM users AS USR WHERE USR.user_id=2 NOT IN ( SELECT * FROM msg_log AS LOG WHERE LOG.msg_id = 8 AND LOG.user_id = USR.user_id)
What happens and is I get the following error:
#1241 - Operand should contain 1 column(s)
I know I'm missing something obvious here but I dont see it...