Remove a join

If your query contains an inner join or an outer join but doesn't retrieve the records you want, you may want to remove the join.

1. In the Table pane, click the join line you want to remove.
2. Press DELETE.

Notes

• When you remove a join, the records included in the result set of the query will change. Depending on the type of join you remove, records may be added to or removed from the result set.
• Deleting a join from a query affects only that query. For example, if Microsoft Query automatically creates an inner join between two tables in your query and you remove the inner join, Microsoft Query will automatically create an inner join between the two tables again if you use them in a different query.