/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 votes393 views2 answers
Import mysql dump command line windows
SQL
0 vote361 views1 answer
Nodejs sql get one to many relationship as array
SQL
10 votes339 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote314 views1 answer
Time in sql server
SQL
8 votes376 views6 answers
Insert command in sql
SQL
1 vote351 views1 answer
Select last row from SQL Table
SQL
1 vote363 views2 answers
Sql server find all foreign keys that reference a column
SQL
0 vote385 views2 answers
How to drop mili second in sql
SQL
7 votes347 views1 answer
Oracle pagination query offset
SQL
15 votes362 views4 answers
Mysql export database command line
SQL