> No it wouldn't. That's the purpose of the GROUP BY.
Worked like a charm, thanks!
-Cameron
--------------------
Cameron Childress
elliptIQ Inc.
p.770.460.1035.232
f.770.460.0963
--
http://www.neighborware.com
America's Leading Community Network Software
> -----Original Message-----
> From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 24, 2001 11:27 AM
> To: SQL
> Subject: RE: Using DISTINCT on a single column of a multi-column select
> st atement
>
>
> > Looks good, but consider these two records
> >
> > [EMAIL PROTECTED], cam, childress, 2
> > [EMAIL PROTECTED], albert, reynolds, 7
> >
> > Would your query return the following?
> >
> > [EMAIL PROTECTED], albert, childress, 2
>
> No it wouldn't. That's the purpose of the GROUP BY.
>
> Funnily enough there's a thread on GROUP BY going
> on over at cf-talk right now.
>
> Nick
>
>
> **********************************************************************
> Information in this email is confidential and may be privileged.
> It is intended for the addressee only. If you have received it in error,
> please notify the sender immediately and delete it from your system.
> You should not otherwise copy it, retransmit it or use or disclose its
> contents to anyone.
> Thank you for your co-operation.
> **********************************************************************
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
