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 Designer removes the join line and the join condition in the statement in the SQL pane.
To remove a join