Chat now with support
Chat with Support

Toad Data Point 5.0 - User Guide

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).

Note: For SQL Server and Oracle 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

  1. 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.  

  2. 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.
  3. (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

  4. (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.

 

Related Topics

Build Queries Visually 

Diagram Relationships

Browse Data in Related Tables

Related Documents