* Mike Morton > Runnint Mysql 3.23.47 > > I have the following two tables: > backorder_notification > ->product_code varchar > ->email varchar > ->date_added date > Products > ->code varchar > ->name varchar > ->other stuff that is not important > > Essencially - I want to get a count of the product codes that are in the > backorder_notification table ordered by count then by product name and > output the display: > > Code Name Count
You can join them all, group, count and order in the same query: SELECT product_code, name, count(product_code) as total FROM backorder_notifications,products WHERE backorder_notifications.product_code = products.code GROUP BY product_code, name ORDER BY total HTH, -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]