Selecting Tables and Views Using SQL Select

Select the tables and views to include in a query. The tables and views that are available depend on the DBMS.

After you have chosen SQL Select as the data source in the New DataWindow wizard, the Select Tables dialog box appears in front of the Table Layout view of the SQL Select painter. For some DBMSs (SQL Anywhere®, for example) you see all tables and views, whether or not you have authorization. If you select a table or view you are not authorized to access, the DBMS issues a message.

For ODBC databases, the tables and views you see depend on the driver for the data source.

To select the tables and views, do one of the following:

Option	Description
Click the name of each table or view to open	Each table you select is highlighted. (To unselect a table, click it again.) Click Open to close the Select Tables dialog box.
Double-click each table or view to open	Each object opens immediately behind the Select Tables dialog box. Click Cancel to close the Select Tables dialog box.

Representations of the selected tables and views display. You can move or size each table to fit the space as needed.