it's returning the DISTINCT for all the values you put in the clause.
so each distinct combination of email, id, display, etc is returned.
what are you trying to do? perhaps there is a better approach.
christopher olive, cto, vp of web development
atnet solutions, inc.
410.931.4092
I would think it returns all distinct columns that you are selecting. I
do not know exactly what is going on in your needs and wanted results, but
maybe a subquery with an IN statement would be a simple enough way to get
those results. Such as:
SELECT Email, My_id, MyDisplay, MyPassword
FROM
the
query runs across [EMAIL PROTECTED] -
Tyler Silcox
email | [EMAIL PROTECTED] (duh.)
- Original Message -
From: Christopher Olive [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 06, 2002 1:45 PM
Subject: RE: distinct query
it's returning the DISTINCT for all
,
and then loop another query, but I'd like to do it the proper way if I
can...
Tyler Silcox
email | [EMAIL PROTECTED]
- Original Message -
From: Aaron Rouse [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 06, 2002 12:16 PM
Subject: Re: distinct query
I would think
olive, cto, vp of web development
atnet solutions, inc.
410.931.4092
http://www.atnetsolutions.com
-Original Message-
From: Tyler Silcox [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 2:01 PM
To: CF-Talk
Subject: Re: distinct query
I'd like to grab all of the distinct
[EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 06, 2002 2:13 PM
Subject: RE: distinct query
the problem is, t-SQL has no way to confirm which one you WANT to keep.
you can pull the distinct email addresses easily enough, but there's
going to have to be some other
06, 2002 11:13 AM
To: CF-Talk
Subject: Re: distinct query
I just tried this out and it still does the same thing. It looks like it
grabs the distinct emails in the subquery (which is good), but then it
returns 4 rows for that email in the main query if they exists...almost
there. I could rig
,
and then loop another query, but I'd like to do it the proper way if I
can...
Tyler Silcox
email | [EMAIL PROTECTED]
- Original Message -
From: Aaron Rouse [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, February 06, 2002 12:16 PM
Subject: Re: distinct query
SELECT email, id, first, last
FROM MyTable
GROUP BY email
HAVING COUNT 1
"tom muck" [EMAIL PROTECTED] on 09/13/2000 04:34:00 PM
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:(bcc: Jerry Tolentino/SIAC)
Subject: Distinct query
Does anyone know how I would go
9 matches
Mail list logo