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).
Note: For SQL Server connections, you can use ANSI joins to create an inner join on a column or equation. To add an ANSI join, click . If you remove the ANSI join, Toad substitutes a regular join.
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.
(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.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Termini di utilizzo Privacy Cookie Preference Center