TableAdapter - get limited columns

I'm new to the Dataset Designer and I'm wondering how to create a select
statement in the same TableAdapter returning only say one column from the table.
it tells me that it's a different schema. How do i get around this?

Just accept the error. This is just telling you that your query result set does
not match that returned by your default SELECT.

But it still returns the other columns I don't necessarily want...

I haven't tried this, bu are you saying that if you write a query for your
TableAdapter that only returns a single column, all columns are actually being
returned?

If i define the adapter to return all (3) columns, and I write a new query and
really only want one to be retruned, it'll return the others, but they will be
null. Do they always have to return data in the data schema defined by the
Adapter?