query question

[hobbybox]

In the past I asked about how to get a list of members that have a certain item in their custom profile field.

I was given this code

SELECT userid, field14
FROM userfield
WHERE field13 = '1'

It works great - it lists the user number and the info in the field....

My questions is this - what do I need to change so it list the user id AND the username with the userfield?

[hobbybox]

Anyone?

[Eikinskjaldi]

Originally Posted by hobbybox

In the past I asked about how to get a list of members that have a certain item in their custom profile field.

I was given this code

SELECT userid, field14
FROM userfield
WHERE field13 = '1'

It works great - it lists the user number and the info in the field....

My questions is this - what do I need to change so it list the user id AND the username with the userfield?

[sql]
select u.userid, username, field14
from user u
join userfield
using (userid)
where field13='1'
[/sql]

[hobbybox]

Works like a charm - Thanks a million!