if count

[kalin m]

hi all...
can somebody explain why a conditional count like this one doesn't work:

count(if(a.Type = "Signature Based Return", a.amount,''))....  group 
by....  order by....
or
if(a.Type = "Signature Based Return", count(a.amount),'') ....    group 
by....   order by...


thanks...

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]