Removing an object does not remove the table from the query

[BOTTOJ]

Can any one help?
I have a single dataprovider that breaks the query up into 3x select statements.
The first query provides the first 6 measures, the second query the next 3 measures and the final query generates the last measure. It works OK.
When I remove the last object from the dataprovider it removes the last query (leaving only 2) OK.
But it leaves the tables and joins (that only the third query required) in the original 2 queries.
I don't want these tables & joins in my queries, they give the wrong answer!. How can I remove them.

 

[ShyamRewaskar]

If you create a new data provider with only two queries only, (6+3) measures. Does these queries contain the tables you dont need and is the output is correct...?

 

[BOTTOJ]

OK,
Thanks for the replies.
deepanwita: when there is more than one query joined in a dataprovider you cannot alter the SQL manually, it is greyed out.
shyamrewaskar: re-created the dataprovider and still got the tables I didn't need. It was a context problem in the universe. Thanks for pointing me in the right direction.

Regards....

John.