sampleq.prg

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

SELECT SALESMAN.NAME, INVOICES.ITOTAL, CUSTOMER.COMPANY,;
  CUSTOMER.CONTACT, CUSTOMER.PHONE;
 FROM CUSTOMER, INVOICES, SALESMAN;
 WHERE INVOICES.CNO = CUSTOMER.CNO;
   AND SALESMAN.ONO = CUSTOMER.ONO;
   AND INVOICES.ITOTAL > 2500;
 ORDER BY SALESMAN.NAME, INVOICES.ITOTAL DESCENDING;
 INTO CURSOR SAMPLE
BROWSE NOMODIFY