Select Tab
You can use the Select tab to configure the SELECT statement for an SQL query or subquery. The Select tab contains the following elements:
Available Fields - Displays the available fields from the source tables.
All Fields - Generates a Select * statement in the SQL code, which selects all of the fields in a table as a group instead of selecting each of the fields individually.
Distinct Rows - Adds the distinct keyword to the SQL code, which causes the SQL procedure to remove duplicate rows from the output.
The Target Fields section of the tab contains a toolbar that enables you to move fields up and down in the list. You can also use it to add, rename, and remove fields. The target fields table lists the target fields for the query. Note that you can edit the target field names and use the drop-down arrow in the Source field to access the Select Field, Expression, Subquery, and Case functions.
SQL Navigation Tree Riser Bar - Displays the components of the current query. You can click the name of a component to open it in a tab.
Data Sample Riser Bar - When displayed, shows sample data for a selected field from a table in the Query Flow Editor or the Data Connections Riser Bar.