Try DISTINCT instead of Unique

        Frederick Hale 
        R.O.A.M. Support 
        *Phone:  816-391-7745
        * Fax:      816-391-5027
        *E-Mail: [EMAIL PROTECTED]


-----Original Message-----
From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 3:33 PM
To: [EMAIL PROTECTED]
Subject: [KCFusion] an easy one


Its been so long since ive done this i forgot how. In an sql statement i
want only unique values of a field. I tried
SELECT Unique (id) as id

but that did not work.
A.


 
 
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
 


______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/[EMAIL PROTECTED]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]

Reply via email to