Hi all, This is probably really simple, but I just can't seem to get it!
To simplify, I have an orders table, with a primary key "OrderID", and a foreign key "ProductID". I want to get the top five most ordered products. I thought maybe using a COUNT with DISTINCT, and restricting the rows returned, but how do I ORDER BY? Any help on how to approach this will be greatly appreciated. Thanks, K. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
