home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a079 / 1.img / FPDG.LZH / VOL2NUM0 / MISC / SELECT1.PRG < prev    next >
Encoding:
Text File  |  1993-02-01  |  808 b   |  15 lines
  1. *****************************************************************
  2. *     * 09/92               SELECT1.PRG                         *
  3. *****************************************************************
  4. *     * Author's Name: Jeb Long                                 *
  5. *     *                                                         *
  6. *     * Description:                                            *
  7. *     * This program illustrates how to use the SQL SELECT      *
  8. *     * command to display population of states and cities for  *
  9. *     * cities with population greater than one million people  *
  10. *****************************************************************
  11. select census.state,city,pop80,population;
  12.  from census,cities ;
  13.  where cities.pop80/1000 > 1000 ;
  14.   .and. census.state=cities.state
  15.