i am having 3 tables named as follows, products, company, productcategory. i am having a table for storing history os selling.named as productssoldhistory. the fields of productssoldhistory table are, soldhistoryid, productid, date, the fields of products table are, productid, productname, copmanyid,
the fields of company table are, companyid, companyname.
i wanna select the companyname of 10 maximum sold products from productssoldhistory table.companyname is in company table.how to use a query for this in mySQL without subqueries?. thanks --- basha