Remove a Join in a Query

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 Designer has created automatically between two tables.

Note   Removing a join from a query does 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 (also called a Cartesian product).

1. In the Database window, click Queries   under Objects, click the query you want to open, and then click Design on the database window toolbar.
2. 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 by using the SHIFT key.

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