User's Guide

Part II. Tutorials

Chapter 8. Joining Tables

In the chapter "Selecting Data from Database Tables", you looked only at the employee table in the database. The sample database consists of nine tables, storing information about our fictional company.

Each box in the diagram represents a table in the database. The list of names in each box are the column names for the table.

In ISQL, you can display a list of tables by pressing the f7 key. The tables for the database are prefixed withdba (the owner of the tables).

The cursor keys can be used to scroll through the list of tables. Each table in the list is prefixed with a user name. This prefix is the ID of the user that created the table---the owner of the table.

Positioning the highlight on a particular table and pressing the Column List button displays the list of columns for that table. The escape key takes you back to the table list and pressing it again will take you back to the command window. Pressing enter instead of escape copies the highlighted table or column name into the command window at the current cursor position.

Press escape to leave the list.