/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

1 vote142 views2 answers
Sql where keyword
SQL
0 vote141 views1 answer
Mysql max number not returning correct value
SQL
0 vote243 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote135 views2 answers
Sqlite unique
SQL
3 votes137 views2 answers
Sql add year to date
SQL
1 vote137 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote132 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote139 views1 answer
Oracle dynamic select into
SQL
0 vote219 views1 answer
Site:av.ru "files"
SQL
1 vote135 views1 answer
Select count distinct multiple columns sql server
SQL