/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

0 vote221 views1 answer
Mssql last day of month
SQL
0 vote211 views1 answer
How to create a table based on another table in mysql
SQL
0 vote194 views1 answer
Mysql identified by syntax error
SQL
1 vote211 views1 answer
Mysql drop key
SQL
42 votes209 views6 answers
Install beautifulsoup
SQL
1 vote186 views1 answer
Not exists mysql
SQL
0 vote192 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote198 views1 answer
How to check which table has data in mysql
SQL
3 votes209 views2 answers
Sql end of month
SQL
6 votes212 views2 answers
Psql load dump
SQL