Re: Counting total files

Bruce Therrien wrote: > We have a database that has a quantity > of files listed for each client record. > We can count the number of clients, but how > do we count the total number of files for > all clients combined? Rather than _count_, calculate that SUM. SELECT COUNT(client), SUM(fpc) FROM tab

Counting total files

We have a database that has a quantity of files listed for each client record. We can count the number of clients, but how do we count the total number of files for all clients combined? -- Bruce Therrien <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql