When you rebuild a query and do not need a table anymore, you have to remove it out of the FROM clause. With Fusion for SQL Server, you can do it visually and quickly.
To remove a table, do either of these actions:
If you have a table shape on the diagram that does not participate in your query (i.e., with no columns selected), it affects the query results. Be attentive and remove unnecessary tables from the diagram.