The following options are available for deleting tables and joins from the Tables and Joins tab:
• To delete a table, select Delete from the right-click actions menu for the table. When a table is deleted, any joins between that table and other tables in the query are also deleted.
• To delete a join, select Delete Join from the right-click actions menu for the join.
• Click Remove Unused Tables and Joins to remove any tables that are not referenced by items on the Select or Constrain, or set as the Main Type, and any joins to those tables. If a table removed by the Remove Unused Tables and Joins action is referenced by an entry on the Criteria tab, that Criteria tab entry is also removed.