charges.qpr

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

SELECT CREDCARD.CARD_ID, CREDCARD.STARTBAL, CREDCARD.BALDATE,;
  DETAILS.TRANS_TYPE, DETAILS.TRANS_DATE, DETAILS.AMT, CREDCARD.TYPE;
 FROM CREDCARD, DETAILS;
 WHERE DETAILS.CARD_ID = CREDCARD.CARD_ID;
   AND DETAILS.TRANS_DATE > CREDCARD.BALDATE;
   AND CREDCARD.CARD_ID <> "    ";
 ORDER BY CREDCARD.CARD_ID;
 INTO CURSOR CHARGES
REPORT FORM REPORTS\CHARGES.FRX PREVIEW