/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

13 votes129 views2 answers
Get tables in database sql
SQL
0 vote135 views2 answers
Greater than sql server
SQL
2 votes154 views1 answer
Find column in all stored procedures sql server
SQL
1 vote129 views1 answer
Partition by sql server
SQL
15 votes129 views4 answers
How to get all tables in sql
SQL
8 votes140 views3 answers
SQL column name
SQL
1 vote138 views1 answer
Sql first day quarter
SQL
0 vote122 views1 answer
First mysql
SQL
1 vote176 views1 answer
Mysql is odd
SQL
0 vote119 views1 answer
Update having mysql
SQL