/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 vote185 views1 answer
Closure in sql
SQL
1 vote200 views1 answer
Oracle split string
SQL
0 vote283 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL
1 vote172 views1 answer
Declare table variable
SQL
0 vote176 views1 answer
Run mssql server terminal
SQL
0 vote195 views1 answer
Postgresql function ROUND
SQL
11 votes170 views2 answers
Insert date sql
SQL
10 votes343 views4 answers
Mysql if else
SQL
0 vote200 views1 answer
T-SQL - Where Used List (Table/View)
SQL
3 votes194 views1 answer
Oracle apex message quit website
SQL