creative :)
-- Sam
-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 4:55 PM
To: CF-Talk
Subject: RE: SQL DISTINCT Question
Thanks Sam, got the following to work but I like yours better ;)
SELECT Email, FirstName, LastName
FROM Users
WHERE
: RE: SQL DISTINCT Question
try:
SELECT email, first(firstname), first(lastname)
FROM people
GROUP BY email;
-- Sam
-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 4:15 PM
To: CF-Talk
Subject: SQL DISTINCT Question
SELECT DISTINCT Email
try:
SELECT email, first(firstname), first(lastname)
FROM people
GROUP BY email;
-- Sam
-Original Message-
From: Jeff Green [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 4:15 PM
To: CF-Talk
Subject: SQL DISTINCT Question
SELECT DISTINCT Email
FROM LinkedEmails
returns a
3 matches
Mail list logo