query.sql

SELECT cfr.DATE, cfr.USER_ID, cfr.CAMPAIGN_ID, SUM(cfr.SPENT_BUDGET) + IFNULL(cfpr.ACTUAL_COST,0) AS SPENT_BUDGET 
	FROM CONSOLIDATE_FINANCIAL_REPORT cfr 
	LEFT JOIN CONSOLIDATE_FINANCIAL_PARTNER_REPORT cfpr on cfpr.CAMPAIGN_ID = cfr.CAMPAIGN_ID and cfpr.DATE = cfr.DATE
	WHERE cfr.DATE = '2013-03-26 00:00:00' AND cfr.USER_ID = 766
	GROUP BY 1,2,3 
	ORDER BY 1,2,3;