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]
