I have a table like this: |ORDERS| |ID | DATE | QNT | LEAD | |342 | 8-12-12 | 32 | F | |345 | 8-15-12 | 12 | S | |349 | 8-16-12 | 9 | R |
I am looking for a way to query it with counts by the LEAD column in order to tell what the number of each type lead is, so that I get something like this: F_LEADS S_LEADS R_LEADS 44 122 32 Is this possible? If so can anyone help with syntax? Thanks, Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
