/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 vote142 views1 answer
Mysql check if lowercase
SQL
0 vote125 views1 answer
Find largest table in mysql database
SQL
11 votes130 views1 answer
Get ddl materialized view oracle
SQL
8 votes159 views4 answers
Reset SQL auto increment
SQL
0 vote126 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
0 vote124 views2 answers
Insert into
SQL
0 vote140 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote133 views4 answers
User defined function sql
SQL
0 vote145 views1 answer
How to access to mysql without root
SQL
0 vote176 views1 answer
How to get table current identity value in sql server
SQL