First off, thanks for answering all my previous questions.

This question is about the Distinct clause in a select query

If I am retrieving multiple columns from a query and only one or two columns need to be distinct, not the whole list of columns how can I do this?

I have tried using the distinct clause in different column positions in the select clause, or putting brackets around. Didn't work.

Thanks

-- Anonymous, June 02, 1999

Answers

Paul,

I don't understand your question very well. Please explain what you would like to see in the result set, using the pubs database as an example.

Eric

-- Anonymous, June 02, 1999