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 table should count the number of clients and calculate their total number of files
HansH -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]