If you don’t want tables to be joined, 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 between tables does not make a permanent change to their relationship. If join information for the tables is stored as part of a database, removing the join removes it only for the current query.
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, the query displays all rows from the first table, each one joined to every row in the second table. Therefore, if you remove a join condition, be sure that you add a different join condition or another search condition or the result set can grow very large.
To remove a join
The Query Designer removes the join line and the join condition in the statement in the SQL pane.