How to select rows that don't have value in a second table
Posted: Thu Jun 03, 2010 12:29 am
Basically I have a main table (accounts) and a meta table (accounts_meta)... The meta table looks like this:
What I want to do is only select accounts that do not have 'referrer_paid' as a row in the accounts_meta table...
Here is my code so far...
Hopefully I am making sense. What am I doing wrong?
Code: Select all
id | account_id | meta_key | meta_valueHere is my code so far...
Code: Select all
SELECT a.* FROM accounts AS a
LEFT JOIN accounts_meta AS am ON a.id = am.account_id AND am.meta_key != 'referrer_paid'
WHERE a.account_referrer != ''
GROUP BY a.id