When using distinct, it is important that you do not include any fields that would be distinct while another field would be duplicated. That sounds very convoluted, I know. Let me explain. If you have two products named "Pee Wee's Bicycle", but they have unique id's, then the distinct command will only work if you don't include the id field. Otherwise, it will accept both records as distinct from one another.
HTH, Aaron On 2/6/06, Adrian Lynch <[EMAIL PROTECTED]> wrote: > Not sure if this applies in your case, but DISTINCT acts across all selected > columns. Would this be the problem? > > Ade > > -----Original Message----- > From: Protoculture [mailto:[EMAIL PROTECTED] > Sent: 06 February 2006 16:09 > To: CF-Talk > Subject: Re: (ms sql) dinstinct not working... > > > >Could you be more specific? What do you expect, and what does it > >return? We need more data to be able to help you. > > > > > Sorry guys for not being more specific. > > I'm getting duplicate rows back. In this case I do not want the duplicate > rows. Not sure why I am getting them. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231459 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
