Using CREATE in SQL Mode › Writing a Sample SQL Query

Writing a Sample SQL Query

Use this section to gain a basic understanding of how the CREATE function works. When you finish, you will understand how to create a basic query with the EDITOR and you will also know some basic facts about CA Dataquery.

This section provides an overview of the procedure involved in creating a planned query. The tutorial presents basic query-building concepts, an introduction to SQL, and lists additional concepts and functions.

You can follow the tutorial and create your own query. Simply choose a table on your database that has both character and numeric data and follow the directions on the following pages (using the correct names for your data).