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 )