RE: Select Distinct not so distinct

I'm trying to select all of the values from a table where type=foo and I would like to eliminate duplicates based on name. EG. SQL="select distinct(name), other, field, names from table where type = foo" -this returns every field where type is a match. SQL="select

RE: Select Distinct not so distinct

D]] Sent: 14 August 2000 11:37 To: '[EMAIL PROTECTED]' Subject: RE: Select Distinct not so distinct I'm trying to select all of the values from a table where type=foo and I would like to eliminate duplicates based on name. EG. SQL="select distinct(name), other, field

RE: Select Distinct not so distinct

when you select distinct(name), foo, bar, baz ... it returns all the distinct combinations of the selected fields. Chris Olive, DOEHRS Website Administrator -Original Message- From: Harold Goodson [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 1:48 PM To: [EMAIL PROTECTED]

RE: Select Distinct not so distinct

The problem with select distinct is if you're select more than one column at a time. It will return distinct ROWS. Not just the one column you specify. --K -Original Message- From: Harold Goodson [mailto:[EMAIL PROTECTED]] Sent: Friday, August 11, 2000 10:48 AM To: [EMAIL PROTECTED]

RE: Select Distinct not so distinct

, August 11, 2000 1:53 PM To: '[EMAIL PROTECTED]' Subject: RE: Select Distinct not so distinct when you select distinct(name), foo, bar, baz ... it returns all the distinct combinations of the selected fields. Chris Olive, DOEHRS Website Administrator -Original Message- From: Harold