Import Table wizard (table from database)

Type a SQL query to retrieve specific records from the database.

The default query will select all records from the selected table.

Page options:

SQL query:

Accept the default query or type your own SQL query to retrieve a specific set of records from the database.

The default query reads: select * from tablename
Frequently used 'selectors'/'operations' in a SQL query are for instance: where and group by.
The exact SQL syntax to be used here may depend on the SQL implementation of the package in which the database or the file was created.

Tip: This option is one of the methods to access a database. For a general introduction, refer to ILWIS objects : tables - databases.

Import Table wizard