Contents Index About this chapter Joining tables using the cross product

ASA Getting Started
  Selecting Data from Multiple Tables
    Introduction

Displaying a list of tables


In Interactive SQL, you can display a list of tables by pressing the F7 key.

The Interactive SQL Lookup Table Name dialog.

Select a table and click Show Columns to see the columns for that table. The Escape key takes you back to the table list, and pressing it again will take you back to the SQL Statements pane. Pressing Enter instead of Escape copies the selected table or column name into the SQL Statements pane at the current cursor position.

Press Escape to leave the list.

For a diagram of the tables in the sample database, see The sample database.


Contents Index About this chapter Joining tables using the cross product