home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a079 / 1.img / FPDG.LZH / VOL2NUM0 / MISC / SQLTRAN.PRG < prev    next >
Encoding:
Text File  |  1993-02-01  |  795 b   |  15 lines
  1. *****************************************************************
  2. *     * 09/92               SQLTRAN.PRG                         *
  3. *****************************************************************
  4. *     * Author's Name: Jeb Long                                 *
  5. *     *                                                         *
  6. *     * Description:                                            *
  7. *     * This program illustrates how to use SQL SELECT command  *
  8. *     * to relate two tables using a one to many relationship.  *
  9. *****************************************************************
  10. SELECT * FROM clients c,transact t , item i;
  11. WHERE t.client_id=  ANY (select x.client_id from clients x) ;
  12.    AND t.inv_no = i.inv_no ;
  13.    ORDER by c.client_id    ;
  14.    INTO CURSOR Trans
  15.