/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 vote129 views2 answers
Mysql set foreign_key_checks=0
SQL
3 votes142 views3 answers
Stop mysql service ubuntu
SQL
0 vote151 views1 answer
Is not numeric sql
SQL
0 vote133 views1 answer
Convert sql server guid to varbinary
SQL
1 vote131 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
3 votes128 views1 answer
Postgresql if null then 0
SQL
34 votes164 views6 answers
Install mysql client ubuntu
SQL
4 votes140 views1 answer
Mac install mysql
SQL
1 vote145 views2 answers
Postgresql check privileges on schema
SQL
6 votes146 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL