home *** CD-ROM | disk | FTP | other *** search
/ Programmer Plus 2007 / Programmer-Plus-2007.iso / Programming / SQL and Data Base / FoxPro 2.06 for Windows / STEP3.QP_ / STEP3.bin
Encoding:
Text File  |  1994-03-10  |  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.