/SQL/Left join in codeigniter query builder

Left join in codeigniter query builder

$this->db->select('p.id, p.photo, p.desc, info.desc');
$this->db->from('products as p');
$this->db->join('lang_info as info', 'info.id=p.id and info.lang='.$this->lang, 'left');
$this->db->where('p.id', $this->product_id);
$this->db->where_in('info.name', ['good', 'bad']);

Similar codes

9 votes150 views2 answers
Sql server check table exists
SQL
13 votes147 views4 answers
Mysql select last 10 rows
SQL
0 vote145 views1 answer
Sql server whoami
SQL
0 vote135 views1 answer
Sql get month and year from date
SQL
0 vote112 views2 answers
Spring properties file for db
SQL
2 votes170 views1 answer
Mysql select true or false
SQL
3 votes193 views2 answers
Oracle drop column
SQL
0 vote160 views1 answer
Querry mysql by 2 columns
SQL
1 vote189 views1 answer
Base64 encode sql server
SQL
0 vote152 views1 answer
Mysql get longest string in column
SQL