RE: Select Distinct not so distinct

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="selec

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

, 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- Fr

RE: Select Distinct not so distinct

ECTED] Subject: Select Distinct not so distinct Hi all, 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"

RE: Select Distinct not so distinct

] Subject: Select Distinct not so distinct Hi all, 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" -thi

Select Distinct not so distinct

Hi all, 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 dis