SELECT suppliercode, productcode, dollarsales FROM SuppTable WHERE productcode IN ( SELECT TOP 10 productcode FROM SuppTable top10 WHERE top10.suppliercode = SuppTable.suppliercode ORDER BY dollarsales DESCENDING )