home *** CD-ROM | disk | FTP | other *** search
- SELECT Customer.state_prov, Customer.sub_length, Customer.cust_id,;
- Customer.last_name;
- FROM Customer;
- WHERE Customer.state_prov IN ("MA","ME","NH","CT","VT","RI");
- AND Customer.renewal <> .T.;
- ORDER BY Customer.state_prov, Customer.sub_length;
-