Left Join in query ?

[ZiNgA BuRgA]

Please take the time to learn SQL, the syntax of your query is probably not what you want.

Good reads:
http://dev.mysql.com/doc/refman/5.0/en/select.html
http://dev.mysql.com/doc/refman/5.0/en/join.html

I was thinking you might trip up on me not specifically putting in the fields you want (I only did the join), but right now I'm feeling incredibly nice at the moment:

SQL Code

SELECT u.username, u.email, u.regip, f.fid3 FROM mybb_users u LEFT JOIN mybb_userfields f ON u.uid=f.ufid

---