mysql clause

[dhimo]

HelloI have two tables 1. products 2. orders in a mysql databaseHow can i select the 5 top sold products from orders? Orders table holds product_id and the quantitythanks

[justsomeguy]

If it's a recent version of MySQL you can use a subquery. I think this would work.

SELECT * FROM products WHERE product_id IN (SELECT product_id, SUM(quantity) FROM orders GROUP BY product_id ORDER BY SUM(quantity) DESC LIMIT 5      )

[dhimo]

mysql says that its not supported. I guesss its not a recent version. any other idea