How to join 2 tables & display them correctly?

Question

http://img293.imageshack.us/img293/857/tablez.jpg Here is a picture of the 2 tables.

The mybb_users table is the table that has the users that signed up for the forum.

The mybb_userfields is the table that contain custom profile field data that they are able to customize & change in their profile.

Now, all I want to do is display all users in rows with the custom profile field data that they provided in their profile(which is in the mybb_userfields table)

How can I display these fields correctly together?

---

For instance, p0gz is a male,lives in AZ,he owns a 360,does not know his bandwidth & Flip Side Phoenix is his team. How can it just be like "p0gz-male-az-360-dont know-flipside phoenix" in a row~???

Answer 1

This looks for me like an ordinary LEFT JOIN

SELECT * FROM mybb_users
  LEFT JOIN mybb_userfields
    ON (mybb_users.uid = mybb_userfields.ufid)
WHERE username = 'p0gz'

This should display every row of the user p0gz

Answer 2

Thanks~!!! I accept Odens answer~!!!