Well i got that, this is what i got:
SELECT pcms2_userfiles.userid, pcms2_users.UserCompanyName
FROM pcms2_userfiles
INNER JOIN pcms2_users
ON pcms2_userfiles.userid=pcms2_users.UserID
But results aren't showing up properly.
Results are just showing that of one customer. (name)
please find attached DB.