[RichieBoy67]

Hello,

I have a list of data to pull and I have the query for most of the data as you can see. I need to add e-mail addresses and usernames to this somehow and I am having a hard time getting this to work.

Here is what I have so far.....

PHP Code:

SELECT userfield.userid
     , userfield.field19
     , userfield.field20
     , userfield.field12
     , userfield.field13
     , userfield.field18
     , userfield.field14
     , userfield.field15
     , userfield.field16
    FROM userfield
INNER
  JOIN user
    ON user.userid = userfield.userid
 WHERE user.usergroupid = 15 


I just need to add e-mail and usernames.... any help would be great..

Thanks