MAIL PROTECTED]>
Sent: Sunday, March 02, 2003 1:12 PM
Subject: Re: Using SUM in a select statement.
> What you are looking for appears to be report layout. Keep in mind that
SQL
> will only return multiple rows, all with the same columns populated.
>
> To even get close to what y
'll either have to use two separate queries or calculate the
totals in your app from the detail data.
HTH,
Tore.
- Original Message -
From: "C. Reeve" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Sunday, March 02, 2003 11:54 AM
Subjec
Hi, Not sure how to explain this - but here is what I need. I have a
hockey pool database with three tables - one has the players and their
stats, one has the team owner, and the 3rd is the reference file that ties
the two together.
I want to be able to do a query for all the players on a partic