On Mon, 1 Mar 2004, Zak McGregor wrote:
> Hi all
>
> is it possible to get a count(1) statemment, for example here:
>
> select count(1) from results where fixture=4916 and winner=away group
> by winner;
>
> to return a 0 value instead of absolutely nothing if no rows match
> fixture=4916 and winner=away? I get absolutely no results at all.
>
Your problem is the GROUP BY. If you take that off it should work as
expected.
Kris Jurka