Using QMF

Chapter 5. Viewing the Data in the Database Using SQL Statements

In this chapter you will learn how to select and view the data in the database by using SQL statements. When you use SQL statements to select and view data, QMF does not prompt you for information as it does with Prompted Query. However, after you learn the basic rules for writing SQL queries, you might find it faster and simpler.

You can also write and run SQL queries from within Windows environments by using the QMF for Windows feature. See Appendix D, The QMF High Performance Option for more information.

When you enter SQL statements on the SQL Query panel, you need to know:

• The name of the table from which you want data
• The column names in the table
• The row conditions you want to specify
• The sequence in which you want the data to appear

For more information about writing SQL queries, see the SQL reference manuals that come with your database management system.