step4.qpr

来自「用汇编语言或高级语言编写的源程序翻译成机器可执行的机器语言程序的工具称为“语言处」· QPR 代码 · 共 10 行

SELECT OFFICES.CITY, SALESMAN.ONO, INVOICES.SALESMAN, SALESMAN.NAME,;
  CUSTOMER.COMPANY, SUM(INVOICES.ITOTAL);
 FROM INVOICES, SALESMAN, OFFICES, CUSTOMER;
 WHERE SALESMAN.SALESMAN = INVOICES.SALESMAN;
   AND OFFICES.ONO = SALESMAN.ONO;
   AND CUSTOMER.CNO = INVOICES.CNO;
 GROUP BY SALESMAN.ONO, INVOICES.SALESMAN, INVOICES.CNO;
 INTO CURSOR STEP4
REPORT FORM STEP4.FRX PREVIEW