/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 vote320 views1 answer
Postgress append string in select
SQL
0 vote340 views1 answer
Postgresql cast as year and month from timestamp
SQL
1 vote334 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
3 votes473 views9 answers
Linq to sql converter online
SQL
0 vote321 views2 answers
Sql max count
SQL
0 vote347 views5 answers
Mode sql course
SQL
3 votes352 views2 answers
Sql add year to date
SQL
2 votes312 views1 answer
Oracle table size
SQL
1 vote321 views1 answer
Sql eliminare un record
SQL
7 votes336 views1 answer
Sql disable safe mode
SQL