uses select statement with both distinct and not distinct

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Theleepan - 07 Dec 2005 19:34 GMT

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!

Reply to this Message

John Vinson - 08 Dec 2005 00:27 GMT

>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]

Reply to this Message