home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a093 / 6.ddi / STEP5.QP_ / STEP5.bin
Encoding:
Text File  |  1993-01-17  |  618 b   |  17 lines
  1. *
  2. * This example is a six-table query which is
  3. * the front end for a fairly complex report.
  4. *
  5. SELECT OFFICES.CITY, SALESMAN.NAME, CUSTOMER.CNO, CUSTOMER.COMPANY,;
  6.   INVOICES.INO, PARTS.DESCRIPT, DETAIL.QTY, DETAIL.PRICE;
  7.  FROM SALESMAN, OFFICES, INVOICES, CUSTOMER, PARTS, DETAIL;
  8.  WHERE OFFICES.ONO = SALESMAN.ONO;
  9.    AND INVOICES.SALESMAN = SALESMAN.SALESMAN;
  10.    AND CUSTOMER.CNO = INVOICES.CNO;
  11.    AND DETAIL.INO = INVOICES.INO;
  12.    AND PARTS.PNO = DETAIL.PNO;
  13.  ORDER BY OFFICES.CITY, SALESMAN.NAME, CUSTOMER.COMPANY, INVOICES.INO,;
  14.   PARTS.DESCRIPT;
  15.  INTO CURSOR STEP5
  16. REPORT FORM STEP5.FRX PREVIEW
  17.