Are nested IF statements valid? Doesn't say anything here: http://www.mysql.com/doc/en/Control_flow_functions.html
Trying to get a conditional count using the following statement - but Im receiving an error. I would use a CASE statement but my version doesn't support it. SUM(IF(AdGroups.Status = 'Paused',IF(AdGroupCriteria.Status,Active,1,0),0)) +-------------+ | version() | +-------------+ | 3.23.57-Max | +-------------+