uses select statement with both distinct and not distinct

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
Click to expand...

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