Re: simple query with distinct keyword

On 12 Sep 2006 10:41:04 -0700, "Welie" <welyakim@xxxxxxxxx> wrote:


issac wrote:
Hi folks

Im trying to do a simple query involving the distinct keyword and an
access 2000 db, but have been frittering with it for amost and hour
and a half and I cant make it work.

This is the SQL I would run if it were valid syntax, but it's not:
Select COLOR1, COLOR2, distinct DESC from COLORS;

TABLE COLORS
---------------------------------------
| COLOR1 | COLOR2 | DESC |
---------------------------------------
.... blue....... red........ugly
....yeller...... red.......orange
....green......blue.......ugly
....red........green......ugly
---------------------------------------

I want to select all columns in the table, but only those rows with
distinct values in the column 'Desc'.


so my returned row countfrom that table would be 2:
.... blue....... red........ugly
....yeller...... red........orange


I am a bit of a newb to SQL, so pardon the 'basicness' of my question


Issac-


Why do you say that the row returned for ugly would be
blue..red...ugly. Maybe you want green..blue..ugly? What I'm saying is
does it matter which row is returned?

thanks for the quick response Welie

short answer is ' no'. I don't care about the row data returned as
long as the Desc Column is distinct.

Thanks for asking and clarifing, BTW. Ordinarily that would be
important, but in this case it's not. In truth, my real table columns
are named 'Team1',' Team2', & 'gameDateTime'. That table actually
contains just 2 records/rows for each unique gameDateTime. The only
difference between the 2 records is that the Teams are transposed
within the 'team' columns-- that's no biggie to my "real" select
statement. As long as I get one of them Im fine.

Since my OP, I have mucked about with 'Min(), and "group By' for
another 30 minutes so, but I still cant seem to get what Im after. Sux
being a total newb. :o(

So the answer is no, I don't care which of the 'dup' records gets
returned in my original color table example. Any one of them will do
as long as 'ugly' in the 'Desc' column is distinct.
.

Relevant Pages

  • Re: simple query with distinct keyword
    ... it for amost and hour and a half and I cant make it work. ... I am a bit of a newb to SQL, so pardon the 'basicness' of my ... Sux being a total newb. ... I don't care which of the 'dup' records ...
    (comp.databases.ms-access)
  • Re: simple query with distinct keyword
    ... issac wrote: ... I am a bit of a newb to SQL, so pardon the 'basicness' of my ... Sux being a total newb. ... I don't care which of the 'dup' records ...
    (comp.databases.ms-access)
  • Re: As VB index help
    ... If you are using Access instead of SQL, ... instead of SQLDataAdapter, OLEDBCONnection instead of SQLConnection, ... I care about build a program with a mdb database in VB. ... (I dont care about SQL servers databases) ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Update access table to sql table
    ... Probably been answered before however i cant get a specific guide through ... create an update query in access and innerjoin X to Y use its 2 primary keys ... and try to update Field1 from temp table Y it takes about 30mins then bombs ... in sql but i just dont understand why the query cant do it alot quicker.i ...
    (microsoft.public.access.queries)
  • Update access table to sql table
    ... Probably been answered before however i cant get a specific guide through ... create an update query in access and innerjoin X to Y use its 2 primary keys ... and try to update Field1 from temp table Y it takes about 30mins then bombs ... in sql but i just dont understand why the query cant do it alot quicker.i ...
    (microsoft.public.access.queries)