Albert Padley <[EMAIL PROTECTED]> wrote on 07/11/2005 07:20:04 PM:
> OK. I'm responding to my own post since I figured out the syntax.
> This allowed me to figure out how to compute the ties as well as the
> wins. How to I compute the losses. I can't use the same technique
> because I'd be look
OK. I'm responding to my own post since I figured out the syntax.
This allowed me to figure out how to compute the ties as well as the
wins. How to I compute the losses. I can't use the same technique
because I'd be looking for '0' in the standingpts column and that
column defaults to '0'.
Shawn,
Thank you. I've been working with what you provided learning as I
figure out the why of each step.
One thing I don't understand is the syntax of these 2 lines:
, sum(if(`standingpts`=3,1,0)) as wins
, sum(if(`standingpts`=3 AND `home_vis` = 'H',1,0) as wins_at_home
Specifically the
Albert Padley <[EMAIL PROTECTED]> wrote on 07/11/2005 02:30:51 PM:
> First, I have spent hours searching the web and the list archives and
> can't find anything helpful.
>
> Second, I'm using MySql 4.0.24
>
> Third, I'm still a novice at query formulation, so be kind.
>
> The Problem---
>
> I
First, I have spent hours searching the web and the list archives and
can't find anything helpful.
Second, I'm using MySql 4.0.24
Third, I'm still a novice at query formulation, so be kind.
The Problem---
I'm working with a new youth soccer league. I need to generate weekly
standings that
