Left Join in query ?

[Imran]

Hi Zinga !

Can you please give me an hint how to use "LEFT JOIN" in sql query. sorry for such an question. I'm running an query where I could find some brief data from "users" table and then from "userfields" table. I don't want to use double query for two different tables, hence little difficult to use this "LEFT JOIN" thingy.

My present query where I am finding brief data from "users" table is;

PHP Code:

$query = $db->simple_select("users", "username, email, regip", "uid=".intval($user_info['uid'])."");

---

then how to insert LEFT JOIN in their to get custom profile field value of that user?

Thanks for helping me out Yumi !