Easily find issues by searching: #<Issue ID>
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam
The quickest way to create a SELECT is to drop a column, table, view or alias into the [Select] Deck. Once items are in the [Select] Deck you can drag to rearrange their order within the select statement created in the SQL Pane. Items dragged to the left appear first in SQL statements in the SQL Pane. If an Alias is present in the [Select] Deck an Alias Icon appears on its right side to make distinguishing Aliases from unaliased objects easier.
To create a Column Expression in the [Select] Deck, right click on a column within it and select [Function]. You will see a list of the available functions such as [AVG, COUNT, COUNT_BIG, MAX, MIN] and [SUM]. This list of functions varies based on the vendor and version of database you are connected to. If you choose [COUNT], you notice that the column name changes in the Select Deck to reflect the Function that has been selected. It will appear as COUNT(column_you_dragged).
You can create your own Custom Column Expression by selecting [Functions > Custom Expression] and typing the Expression and providing an Alias name for it. If you have [Query > Quote Identifiers] selected, then the SQL Pane will show your table and column surrounded by quotes.
It's possible to make an Alias from any item in the [Select] Deck by right clicking it and choosing [Create Alias...]
After entering the text for your Alias and clicking [OK], the item name will change to display the Alias text you used. The Alias Icon will appear to its right. The SQL Pane reflects the Alias use in your SELECT statement as well.
You can determine an Alias's origin by mouse hovering the item and viewing its tooltip details.
Left clicking the menu triangle in the [Select] Deck allows you to Create SQL Expressions, Create Subqueries, choose [DISTINCT] or [ALL] (or other options depending on vendor), [Clear the Select Deck] of all items, [Select All] items on the [Select] Deck or [Hide] the deck.
Choosing [Create SQL Expression...] from the [Select] Deck menu triangle...
generates the [SQL Expression] Dialog, allowing you to write out your own SQL Expression.
Any expressions you type in the [Select] Deck [SQL Expression] Dialog appear as items in the Select Deck. Mouse hover over an Expression in the [Select] Deck produces a tooltip letting you know what the Expression contents are.
SQL Expressions can be created in the Query Builder in a variety of other ways.