home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a087 / 6.ddi / STEP3.QP_ / STEP3.bin
Encoding:
Text File  |  1994-02-02  |  310 b   |  9 lines
  1. SELECT OFFICES.CITY, SALESMAN.ONO, INVOICES.SALESMAN, SALESMAN.NAME,;
  2.   SUM(INVOICES.ITOTAL);
  3.  FROM INVOICES, SALESMAN, OFFICES;
  4.  WHERE SALESMAN.SALESMAN = INVOICES.SALESMAN;
  5.    AND OFFICES.ONO = SALESMAN.ONO;
  6.  GROUP BY SALESMAN.ONO, INVOICES.SALESMAN;
  7.  INTO CURSOR STEP3
  8. REPORT FORM STEP3.FRX PREVIEW
  9.