Hi have you tried Hiding the fields on the Data Source Tab. Connect to the data then open the Data Source tab. Right click the columns in the data you want to omit and select Hide - Then refresh the data
Will that meet your need?
Custom SQL will work if you want.
Jim's solution of hiding the fields will also work. I believe Tableau will specifically select the fields from your tables which are in the view, so hiding them I *think* excludes them from the SELECT statement.
I'll have to check that Tomorrow, was not sure what exactly hiding a column did in the query if it caused it run in the query just "Hide" the field from view. If that's the case, Exclude would be a better word to use :-S.
Thanks guy's I'll keep you posted.