Depending on how you might want to further refine your query, you can perform the following steps to join tables, apply conditions, or group and order rows:
-
To create an SQL JOIN
between tables, select a reference key in one table, then drag it to the appropriate row
in another table.
To modify the JOIN, right-click its red square, then
click edit in the popup menu.
- To add a condition or expression, right-click a row in the query workspace, and select the appropriate action from the menu.
-
To order or group by a specific row,
drag a statement from the SELECT category in the upper left pane and
drop it into the GROUP BY or ORDER BY
category.