On Thu, Jan 09, 2003 at 12:24:28PM -0600, Paul DuBois wrote:
...
 You probably want SUM(col3 < col4,1,0) instead.
  Hey Paul,

  Am I missing something here?

  I did not think that SUM(col3 < col4,1,0) would be valid syntax?


  Cheers!
--
 Zak Greant <[EMAIL PROTECTED]> | MySQL Advocate |  http://zak.fooassociates.com
Zak's correct.  I erred.  The expression would use IF() inside a SUM():

    SUM(IF(col3 < col4,1,0))


Sheesh.

---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to