GoFuckYourself.com - Adult Webmaster Forum - View Single Post

M_M · 07-16-2004, 12:58 PM

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) OR t2.campaign_id IS NULL

07-16-2004, 12:58 PM
M_M Confirmed User Join Date: May 2004 Posts: 1,167	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) OR t2.campaign_id IS NULL