Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Build Queries Visually > Join Columns

Join Columns

You can create relationships between columns in tables using the Join option. The Query Builder and Master Detail Browser visually display the relationship between tables by creating a line between the tables. When adding tables the diagram pane, relationship lines are automatically created if a constraint or relationship exists in the database for the added tables. A line with an arrow pointing in the direction of the join indicates a one to one relationship.

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. The diamond on the relationship line indicates the type of join as follows:

	Inner join
	Left outer join
	Right outer join
	Cross join

Note: By default, all joins are initially created as Inner Joins.

(Query Builder only) Double-click and review the following for additional information:

Select all rows from table_name1	Select this checkbox tocreate a cross join.
Select all rows from table_name2	Select this checkbox to create a cross join.

Tip: To remove a join, right-click and select Remove.