home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a078 / 1.img / OSFQ04.QPR < prev    next >
Encoding:
Text File  |  1993-05-10  |  259 b   |  7 lines

  1. SELECT Customer.state_prov, Customer.sub_length, Customer.cust_id,;
  2.   Customer.last_name;
  3.  FROM Customer;
  4.  WHERE Customer.state_prov IN ("MA","ME","NH","CT","VT","RI");
  5.    AND Customer.renewal <> .T.;
  6.  ORDER BY Customer.state_prov, Customer.sub_length;
  7.