📄 step5.qpr
字号:
*
* This example is a six-table query which is
* the front end for a fairly complex report.
*
SELECT OFFICES.CITY, SALESMAN.NAME, CUSTOMER.CNO, CUSTOMER.COMPANY,;
INVOICES.INO, PARTS.DESCRIPT, DETAIL.QTY, DETAIL.PRICE;
FROM SALESMAN, OFFICES, INVOICES, CUSTOMER, PARTS, DETAIL;
WHERE OFFICES.ONO = SALESMAN.ONO;
AND INVOICES.SALESMAN = SALESMAN.SALESMAN;
AND CUSTOMER.CNO = INVOICES.CNO;
AND DETAIL.INO = INVOICES.INO;
AND PARTS.PNO = DETAIL.PNO;
ORDER BY OFFICES.CITY, SALESMAN.NAME, CUSTOMER.COMPANY, INVOICES.INO,;
PARTS.DESCRIPT;
INTO CURSOR STEP5
REPORT FORM STEP5.FRX PREVIEW
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -