Re: Distinct Help

want a full list of UserNames you're bound to get repeated UserID's. If you want a list of all UserID's that only have one UserName you could say SELECT UserID, count(UserName) FROM Member GROUP BY UserID HAVING count(UserName) = 0 but I'm not sure that's what you want... is it? Nick de Voil De

Re: Distinct Help

you could say SELECT UserID, count(UserName) FROM Member GROUP BY UserID HAVING count(UserName) = 0 but I'm not sure that's what you want... is it? Nick de Voil De Voil Consulting [EMAIL PROTECTED] Tel +44 20

<    1   2   3