Building Simple SELECT Statements

This section starts with a simple SQL statement and sequentially builds more complex statements, explaining how the Visual SQL Query Builder is used to create SELECT statements, how it displays the results to the user, and how the results are displayed in a dialog form.

Note: All the examples in this section apply to the GIS database.

Note: The following examples reflect different settings in the Standard Form Items dialog.

Note: You can either type an SQL statement directly into the SQL Select Statement field or you can proceed with following procedures and have OpenTunnel Designer generate an SQL statement for you.