/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

4 votes327 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote343 views1 answer
Increase speed of like queries postgres
SQL
1 vote349 views1 answer
Sysdate in sql
SQL
0 vote362 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote361 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote411 views2 answers
Suse Linux restart MySQL
SQL
4 votes351 views2 answers
Insert current date in mysql
SQL
3 votes382 views1 answer
Sql set null
SQL
13 votes371 views1 answer
Views in sql
SQL
1 vote424 views1 answer
Oracle columns table
SQL