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