Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
If you don't 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 Tools (Visual Database Tools) has been created automatically between two tables.
Note
Removing a join from a query doesn't 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.
Remove a join
- In the Diagram pane (Visual Database Tools), select the join line for the join to remove, and then press the
DELETEkey. 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 (Visual Database Tools).