Querying the TurboNet Database

The turbonet database lives on Daffy.

  1. Set the proper printer as default.
  2. Run the SQL 6.5 SQL Enterprise Manager.
  3. Find the TurboNet database and tables.
  4. Run a query of the form: 

select cust_no, name, home_phone, work_phone from tcustomers where cust_id in

   (select cust_id from tbilling where account_type <> "STANDARD PPP ACCESS' and end_date < '5/1/2000')

note that leaving a space in front of the second line makes it a continuation of the first line. 

Print from the file menu.