Designing SQL Statements

You can use the SQL Statement Builder to create several different kinds of SQL statements. These statements can request information from the database (SELECT statements) or request modifications to the database (UPDATE and DELETE statements), add new data to the database (INSERT statements) or execute stored procedures (CALL statements).

You can create, load, and delete statements from the menus or with the graphical interface. Refer to the following sections:

• Creating Statements

• Loading Existing Statements

• Saving Statements

• Deleting Statements

• Database Results Caching

• Complex Outer Joins

• Setting Limits on the Number of Records Retrieved

• Omitting Duplicate Records

• Grouping Records Together

• Extracting Information from a Database

• Modifying a Database

• Executing Stored Procedures and Functions

• Manipulating the SQL Statements

For information on creating statements with advanced expressions and criteria with the SQL Statement Builder, see the Building Precision SQL Statements chapter.

---