/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

11 votes127 views1 answer
How to get ddl for materialized view
SQL
5 votes212 views2 answers
Mysql date greater than 30 days
SQL
0 vote118 views1 answer
Openquery insert into linked server
SQL
1 vote144 views1 answer
Mysql update inner
SQL
0 vote128 views1 answer
Mysql grant grant option
SQL
62 votes169 views8 answers
Mysql add column
SQL
0 vote120 views1 answer
Heavy table in mysql
SQL
3 votes129 views1 answer
Get all elements sql
SQL
1 vote123 views2 answers
Update with inner join sql server
SQL
0 vote124 views1 answer
Sql server alter table add column tinyint
SQL