home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a079 / 1.img / FPDG.LZH / VOL2NUM0 / MISC / BOSS.PRG < prev    next >
Encoding:
Text File  |  1993-01-31  |  717 b   |  13 lines
  1. *****************************************************************
  2. *     * 09/92               BOSS.PRG                            *
  3. *****************************************************************
  4. *     * Author's Name: Jeb Long                                 *
  5. *     *                                                         *
  6. *     * Description:                                            *
  7. *     * This program illustrates the use of SQL SELECT command  *
  8. *     * to do a self join                                       *
  9. *****************************************************************
  10. SELECT * FROM Employee e ;
  11.   WHERE e.salary > (SELECT f.salary FROM Employee f;
  12.    WHERE f.empno = e.boss_id)
  13.