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