select ListName, count(*), sum(Info is not null) from ListTable group by ListName
===== Original Message Follows ===== From: "John Berman" <[EMAIL PROTECTED]> Subject: Count of two fields Wonder if you can help I have a table with a number of fields but the List Name Member Info Ever member in the table has a list and some members have something in the info field, Im after a count by list name So for instance the result im after would be something like List1 55 3 So for list1 there are 55 members associated with is and out of the 55 3 have something in the info field Help appreciated -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
