Types of SQL statements

The following types of SQL statements 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. Select Unique is not really a separate type, but rather is created by using the verb SELECT with the modifier DISTINCT added. If the user is running a Java 2-enabled browser, then Select Unique is not shown as a separate type.

• 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.

The following table shows which tabs appear for each type of SQL statement.

• A (1) indicates that the tab appears only if the user is running a Java 1 browser.
• A (2) indicates that the tab appears only if the user is running a Java 2-enabled browser.

Tab:	Select	Select Unique	Insert	Update	Delete
Start (2)	X		X	X	X
Logon	X	X	X	X	X
Tables	X	X	X	X	X
Columns	X	X
Join (1), Joins (2)	X	X
Condition (1), Conditions (2)	X	X		X	X
Sort (1), Order (2)	X	X
Output	X	X
SQL (1), Review (2)	X	X	X	X	X
Results	X	X
Insert			X
Update				X