home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a087 / 6.ddi / SALESMAN.QP_ / SALESMAN.bin
Encoding:
Text File  |  1994-02-02  |  272 b   |  7 lines
  1. SELECT Salesman.salesman, Offices.city, SUM(Invoices.itotal);
  2.  FROM Invoices, Salesman, Offices;
  3.  WHERE Salesman.salesman = Invoices.salesman;
  4.    AND Offices.ono = Salesman.ono;
  5.  GROUP BY Salesman.salesman, Offices.city;
  6.  ORDER BY Salesman.salesman, Offices.city, 3
  7.