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