/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 votes151 views2 answers
Sql percentage
SQL
8 votes166 views2 answers
Select current_timestamp - interval '3 days';
SQL
-1 vote154 views4 answers
Restart mysql server ubuntu
SQL
1 vote140 views1 answer
Create sample data postgresql
SQL
0 vote156 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote143 views4 answers
Sql year
SQL
1 vote163 views1 answer
Mysql strict_trans_tables
SQL
2 votes152 views1 answer
Drop all database tables oracle sql developer
SQL
11 votes149 views2 answers
Having in sql
SQL
7 votes146 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL