it put the rows together at this point for the distinct... the results are correct....
----- Original Message ----- From: "Russ 'Snake' Michaels" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 05, 2002 3:48 PM Subject: [ cf-dev ] distinct > I am sure this is weird, but correct me if I am wrong. > > I have lookup tables like this > > USERID, OTHERID > > both columns will have multiple copies of values. > e.g > > 1,2 > 1,3 > 1,4 > 2,2 > 2,4 > > I need to get back only distinct UDERID's > > so a select distinct USERID from table > > works fine > but as I also need the other column, when I add select DISTINCR USERID, > OTHERID > I get multiple rows containing the same USERID back again > > what's up with that > > /Russ > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] __________________________________________________ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
