The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
query question
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? |
#2
|
|||
|
|||
Anyone?
|
#3
|
||||
|
||||
Quote:
select u.userid, username, field14 from user u join userfield using (userid) where field13='1' [/sql] |
#4
|
|||
|
|||
Works like a charm - Thanks a million!
|
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|