Database tables

The following SQL statement types are defined:

• Select
  Allows you to generate SQL queries that contain all rows that match the specified conditions, even if the rows are duplicates. The queries can be sent to a display or to a file.

• Select Unique
  Allows you to generate SQL queries that contain all unique rows that match the specified conditions. The queries can be sent to a display or to a file.

• Insert
  Allows you to generate SQL statements to insert new rows into a database.

• Update
  Allows you to generate SQL statements to update rows in a database.

• Delete
  Allows you to delete specified rows from a database.

Depending on the SQL statement type you select, you see only the valid tabs for these types of statements. This table indicates the valid tabs for each type of SQL statement.

	Select	Select Unique	Insert	Update	Delete
Logon	X	X	X	X	X
Tables	X	X	X	X	X
Join	X	X
Condition	X	X		X	X
Columns	X	X
Sort	X	X
Output	X	X
SQL	X	X	X	X	X
Results
Insert			X
Update				X

The tables in this list are identified by the currently-selected connection alias, as specified in the Database URL field on the Logon tab.