Quote:
Originally posted by M_M
SELECT t1.campaign_id, t2.revenue FROM table1 t1 LEFT JOIN table2 t2 ON t1.campaign_id=t2.campaign_id WHERE (t2.year=2004 AND t2.month=12 AND t1.uid=851) OR t2.campaign_id IS NULL
|
Tried that one too but doesn't work. That one returns ALL rows from table1, because of the OR I suspect....