/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 vote203 views2 answers
Plan d'exécution requete oracle autotracer
SQL
0 vote192 views1 answer
Like sql for second letter of the family name
SQL
0 vote204 views1 answer
Sql string length postgresql
SQL
2 votes200 views1 answer
Set column to not null mysql
SQL
1 vote226 views1 answer
Hangfire clear all jobs
SQL
0 vote219 views2 answers
Sql query for getting details by id
SQL
1 vote250 views1 answer
Mysql show long running queries
SQL
10 votes215 views2 answers
Forgot my mysql password mac
SQL
0 vote167 views2 answers
Spring properties file for db
SQL
1 vote206 views1 answer
Mysql show queries running
SQL