home *** CD-ROM | disk | FTP | other *** search
/ Win 3.11 Apps / win311aps.iso / FOXPRO / STEP4.QP_ / STEP4.bin
Text File  |  1995-05-15  |  389b  |  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.