Re: Using SUM in a select statement.

2003-03-02 Thread C. Reeve
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

Re: Using SUM in a select statement.

2003-03-02 Thread Tore Bostrup
'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

Using SUM in a select statement.

2003-03-02 Thread C. Reeve
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