home *** CD-ROM | disk | FTP | other *** search
/ Liren Large Software Subsidy 5 / 05.iso / a / a078 / 1.img / LSNQ04.QPR < prev    next >
Encoding:
Text File  |  1993-05-10  |  349 b   |  9 lines
  1. SELECT Customer.cust_id, Customer.last_name, Customer.first_name,;
  2.   Customer.renewal, Customer.sub_length, Customer.sub_date;
  3.  FROM Customer;
  4.  WHERE Customer.state_prov = "NY";
  5.    AND Customer.sub_length > 23;
  6.    OR (Customer.sub_date > CTOD("09/21/92");
  7.    AND Customer.state_prov = "NY");
  8.  ORDER BY Customer.sub_length, Customer.sub_date
  9.