/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 vote319 views1 answer
Geopoint from json mysql function
SQL
14 votes316 views4 answers
Remove record from table sql
SQL
2 votes329 views3 answers
Sqlite3.OperationalError: near "7": syntax error
SQL
1 vote327 views1 answer
Spark sql convert string to date
SQL
4 votes313 views1 answer
Search column by name mysql
SQL
0 vote291 views1 answer
Mysql group by derived column
SQL
1 vote316 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
40 votes399 views4 answers
PostgreSQL add column
SQL
0 vote292 views1 answer
Order by monthly in sql
SQL
0 vote315 views1 answer
Write a query to peint the pattern P(20)
SQL