You could group on the column which you want to be distinct. That should give you the same results.
<!----------------//------ andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: Monday, February 06, 2006 10:39 AM To: CF-Talk Subject: Re: (ms sql) dinstinct not working... >Not sure if this applies in your case, but DISTINCT acts across all selected >columns. Would this be the problem? Perhaps yes... would there be any way to select DISTINCT on certain columns ONLY ( but still retrieving the other columns as well? If so, how is that SQL written? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231460 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
