/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 vote230 views4 answers
Sql server date format yyyy-mm-dd
SQL
1 vote194 views2 answers
Grab part of a string sql
SQL
0 vote250 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
3 votes208 views2 answers
Oracle apex view logs
SQL
20 votes185 views1 answer
Get all table name in sql through php
SQL
3 votes204 views3 answers
Mysql order by list
SQL
1 vote204 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
-2 votes212 views1 answer
Group functions in sql
SQL
0 vote226 views1 answer
Sql select lowest value row
SQL
0 vote189 views1 answer
Vbscript create ADODB.Connection
SQL