/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

5 votes216 views2 answers
Oracle list columns schema
SQL
0 vote191 views1 answer
Separator mysql
SQL
1 vote227 views2 answers
Begin transaction in sql
SQL
0 vote229 views1 answer
Group by max date
SQL
0 vote222 views1 answer
Mysql update table from select on another table
SQL
0 vote208 views1 answer
Delete insert record in sql server
SQL
2 votes214 views3 answers
Postgresql reset auto increment
SQL
0 vote216 views2 answers
Oracle create chain rule
SQL
12 votes209 views1 answer
How to change the value of a table in sql
SQL
1 vote221 views2 answers
Last working day in week date function in sql
SQL