Select from table A where not in table B
Posted on 2011-02-23
I'm trying to select rows from table A where there isn't a corresponding row in table B
I'm trying this but it's not returning any results at all. Table A has 30 records and at the minute table B has none, so it should return every row in table A.
LEFT JOIN lead_activity ON leads.id = lead_activity.lead_id
WHERE lead_activity.id = ''
LIMIT 0 , 30