Join Columns
You can create relationships between columns in tables using the Join option. The Query Builder, the Database Diagram, and the Master Detail Browser visually display the relationship between tables by creating a line between the tables. When adding tables to the diagram pane, relationship lines are automatically created if a constraint or relationship exists in the database for the added tables. The arrow in the relationship line indicates the direction of the join (Query Builder only).
To join two columns
-
Drag a column from one object to a column in a second object that you want to join. Toad draws a line between the tables with an arrow in the direction of the join.
Note: By default, all joins are initially created as Inner Joins.
- To visualize how values (rows) are distributed within the joined tables, you can analyze the join. To analyze the join, click on the relationship line (or right-click the line and select Analyze Join). The Analyze Join pane opens to display a Venn diagram and data grid. See Analyze Joins for more information.
-
(Query Builder only) After viewing how values are distributed in the tables, you can change the join type (for example, you might want to change the inner join to a right or left outer join).
To change the join type, right-click the join and select one or both of the following:
Select All Rows from TABLE_A
Select All Rows from TABLE_B
The join icon changes based on your selection. Review the following join types.
Inner join
Left outer join
Right outer join
Full outer join
-
(Query Builder only) To view or modify join properties, right-click the join and select Properties.
Tip: To remove a join, right-click the join icon and select Remove.