]]
Sent: Thursday, May 24, 2001 11:21 PM
To: CF-Talk
Subject: RE: OT DBMS select distinct
The key word distinct does not work that way. It will only allow
duplicate
record sets but does nothing for individual fields unless it is a one
field
query. A work around is as follows but depending
Sorry for the off topic but how do you select distinct only on one of
several items in a select statement.
I only want the unique names from the query below but this doesn't seem to
be working.
Winnt 4 sp6
CF 4.5.2
Access or SQL 6.5
select
r.ResourceID,
distinct r.Name,
r.Description,
,
p.ApplicationID
from
Resources as r LEFT OUTER JOIN
Policies as p
ON
r.ResourceID = p.ResourceID
where r.name in (select distinct name from resources)
-Original Message-
From: Bryan LaPlante [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 24, 2001 10:04 PM
To: CF-Talk
Subject: OT DBMS select
up.
Bryan
- Original Message -
From: John [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, May 24, 2001 10:20 PM
Subject: RE: OT DBMS select distinct
The key word distinct does not work that way. It will only allow
duplicate
record sets but does nothing for individual
4 matches
Mail list logo