uses select statement with both distinct and not distinct

[Theleepan]

Hi i want a select statement that will choose distinct and not distinct. i
have a select statement with 10 field that is distinct select and i want the
11 field to not be distinct select. how do i write the select statement. in
one query. thanks!

 

[John Vinson]

Hi i want a select statement that will choose distinct and not distinct. i
have a select statement with 10 field that is distinct select and i want the
11 field to not be distinct select. how do i write the select statement. in
one query. thanks!

I want my new car to be blue and not blue.

Your question, as posed, is meaningless. The query is either distinct,
or it's not distinct.

Could you give an example of the data that you have in the table, and
what you want to see?

John W. Vinson[MVP]