Are nested IF statements valid? Doesn't say anything here: http://www.mysql.com/doc/en/Control_flow_functions.html
Yes, you can nest them, but you must do so correctly. :-)
Your inner IF() below appears to have four arguments.
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 | +-------------+
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
