/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 vote231 views1 answer
Mysql update even / odd rows
SQL
12 votes224 views4 answers
Mysql version
SQL
0 vote221 views1 answer
Mysql update privileges
SQL
1 vote220 views1 answer
How to truncate a table in databse
SQL
5 votes236 views2 answers
Oracle list columns
SQL
0 vote264 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote254 views1 answer
Check constraint is violated
SQL
12 votes251 views2 answers
Select into insert sql server
SQL
6 votes223 views2 answers
Join vs union
SQL
0 vote234 views2 answers
Execute stored procedure without db set
SQL