home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a079 / 1.img / FPDG.LZH / VOL2NUM0 / MISC / CENSUS12.QPR < prev    next >
Encoding:
Text File  |  1992-11-11  |  198 b   |  6 lines
  1. SELECT Census.state, Census.population, Cities.city, Cities.pop88;
  2.  FROM Census, Cities;
  3.  WHERE Cities.state = Census.state;
  4.    AND UPPER(Census.state) = "C";
  5.  ORDER BY Cities.pop88 DESCENDING
  6.