RE: Aggregate Functions - Count, Sum

2001-07-11 Thread Don Read
On 11-Jul-01 Nelson Goforth wrote: I'm trying to return several pieces of information from a small table. Table is 'tickets': idCHAR(50) group CHAR(50) issuedDATE used DATE 'issued' and 'used' are NULL until a date is entered. The found set is

RE: Aggregate Functions - Count, Sum

2001-07-11 Thread Nelson Goforth
Don, thank you. The SELECT statement worked perfectly just as you suggested. Though the books I have on MySQL are pretty good, trying to figure more and more esoteric statements out is a bit of a challenge, even just in terms of syntax. Nelson In looking via SELECT * FROM tickets, the

Aggregate Functions - Count, Sum

2001-07-10 Thread Nelson Goforth
I'm trying to return several pieces of information from a small table. Table is 'tickets': idCHAR(50) group CHAR(50) issuedDATE used DATE 'issued' and 'used' are NULL until a date is entered. The found set is generally based on the 'group'. I want the actual