home *** CD-ROM | disk | FTP | other *** search
/ Total C++ 2 / TOTALCTWO.iso / vfp5.0 / vfp / samples / data / topten.qpr < prev    next >
Text File  |  1996-08-21  |  243b  |  7 lines
  1. SELECT TOP 10 Products.prod_name,;
  2.   SUM( Orditems.unit_price*  Orditems.quantity);
  3.  FROM  testdata!products INNER JOIN testdata!orditems ;
  4.    ON  Products.product_id = Orditems.product_id;
  5.  GROUP BY Products.prod_name;
  6.  ORDER BY 2 DESC
  7.