Check 'No Duplicates' under 'Miscellaneous Tab' or use GROUP BY.

>Hello Everyone!!!
>I am tring to put together a list of states from a table of given locations.
>I want to set up this remote view for Distinct States. But I don't know how to do
>this in the view Designer.
>
>Question:
>How do I set up a "Select Distinct" view in the view designer or is there something else that I have to do.
>
>
>Thanks in Advance