Share via


How to: Remove Joins

If you do not want tables to be joined via an inner join or an outer join, you can remove the join between them. For example, you might remove a join that the Query and View Designer has been created automatically between two tables.

Note

Removing a join from a query does not alter the underlying relationship in the database.

If two joined tables are part of your query and you remove all join conditions between them, the resulting query becomes the product of both tables — that is, it becomes a CROSS JOIN. For more information, see Types of Joins.

Note

Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Visual Studio Settings.

To remove a join

  • In the Diagram pane, select the join line for the join to remove, and then press the DELETE key. You can select and delete multiple join lines at one time.

The Query and View Designer removes the join line and alters the statement in the SQL pane.

See Also

Tasks

How to: Join Tables Manually

Concepts

How to: Join Tables Automatically

Other Resources

Querying with Joins