Adding Tables to Query
The first step in building a SELECT query is to decide which tables and views you need to add to SELECT list.
Adding Tables and Views
To add tables and views to the query, simply drag-and-drop them from the Database Explorer tree to the query diagram.
You can also select required tables in Database Explorer, right-click the selected tables, and then click Send To, and then click Query Builder. Table shapes with the lists of table columns appear. Select the columns to include them into the SELECT list. Check All Columns option if you want to select all the fields in a table.
After you have added tables to the query diagram, you can use the Selection tab of the tabbed editor to adjust the query to your needs.
Note
A connection you are using while dragging a table must be the connection of the query document. You will not be able to perform a drag and drop operation from another connection.
Note
The appearance may slightly vary depending on the product you use.
Besides tables, you can also add views to the diagram.
They are displayed as shapes with the list of columns which you can mark to include in the SELECT list.
