Michael, Have you tried NVL() as opposed to isnull() Dave Crozier
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MB Software Solutions Sent: 01 May 2007 03:11 To: Profox Subject: [NF] Problem with MySQL COUNT syntax For some reason, the nCount field below gets defined as a character field. !?!?!!?!????????? SELECT t1.iid, t1.cTown, IFNULL(COUNT(p1.iid),0) as nCount, IFNULL(SUM(p1.nAmount),0) as nSum FROM towns t1 LEFT JOIN accounts a1 ON a1.itownid = t1.iid LEFT JOIN payment_header p1 ON p1.iacctid = a1.iid AND p1.dDate = '<<lcDate>>' AND p1.iCount = 1 WHERE t1.iCompID = <<this.iCompID>> GROUP BY 1,2 Why isn't it an integer/number? -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
