How to delete a join

Unused joins can be deleted from a model ( for example, if a join no longer represents a relationship).

To delete a join

Select the SQL tab, and then expand Tables.
Expand the table containing the join to be deleted.
Expand Joins, right-click the join to be deleted, and then click Delete.
When asked to confirm the deletion, click OK.