You can create a SELECT, INSERT, UPDATE, DELETE, FULLSELECT,
or WITH statement by selecting the statement type in the New
SQL or XQuery Script window. You will now create a SELECT
statement for the VIDEOS database.
The SELECT statement is created from the template and opens
in the SQL Query Builder, as shown here:

The SQL Query Builder
has three panes:
- SQL Source
- The top pane shows the SQL source for your statement as it is
being built.
- Tables
- The middle pane shows the tables and table columns that are added
to the statement.
- Design
- The bottom pane is used to provide details for statement clauses.
This pane changes depending on the statement type being edited.
You will use all of these panes throughout this
tutorial.
In addition to the Data Project Explorer view, you
can use the following three views with the SQL Query Builder:
- Outline
- Shows the statement that you are currently working on. For more
complex statements such as WITH and FULLSELECT that can include, for
example, subselects and common table expressions, the Outline view
shows the structure of the statement.
- Data Source Explorer
- Each defined data connection is shown in this view. You can use
the Tables folder under a connection as a source for adding tables
to an SQL statement in the SQL Query Builder.
- SQL Results
- Shows the messages, parameters, and results that are related to
running your SQL statement.
The SELECT statement that you created is already
open in the SQL Query Builder, so you can continue to construct it.
You are creating only a SELECT statement in this tutorial, but you
can also use the SQL Source pane, the Tables pane, and the Design
pane of the SQL Query Builder to create INSERT, UPDATE, DELETE, FULLSELECT,
and WITH SQL statements.