You can remove unwanted joins from the data model. Removing a join has no effect on the underlying database tables or any server-defined joins between them. A deleted join is removed from consideration only within the data model.
To remove a join from a data model, select the join and select Remove on the shortcut menu.