Mysql join in codeigniter

Vijay 22:44 codeigniter join
                        $this->db->select('*');
$this->db->from("table1");
$this->db->join("table2","users.id=table1.user_id","left");