/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

2 votes190 views2 answers
Function in sql
SQL
1 vote204 views1 answer
Sqlite create index
SQL
12 votes206 views1 answer
Docker run mysql image
SQL
5 votes193 views4 answers
Describe table postgres
SQL
3 votes223 views3 answers
Update con select postgresql
SQL
11 votes232 views1 answer
Ddl view
SQL
0 vote204 views1 answer
Sql server select ignore dupplicates
SQL
7 votes192 views1 answer
Sql management studio display line numbers
SQL
5 votes208 views1 answer
JBDC
SQL
3 votes216 views2 answers
Monthname sql
SQL