/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

3 votes332 views1 answer
Oracle limit user tablespace
SQL
11 votes342 views2 answers
Safe mode off mysql
SQL
23 votes371 views4 answers
How to show all users in mysql
SQL
0 vote351 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
4 votes445 views1 answer
How to check last gather stats on table in oracle
SQL
0 vote369 views1 answer
Oracle locked objects
SQL
0 vote364 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
0 vote380 views1 answer
Sql log file inof
SQL
0 vote382 views1 answer
Updating database in sql
SQL
0 vote354 views1 answer
Postgresql certain first 4 characters in string
SQL