/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

3 votes99 views1 answer
MySQL DELETE JOIN
SQL
0 vote113 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote112 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
1 vote103 views1 answer
Adding a default constraint to an existing column in sql
SQL
0 vote110 views2 answers
How to use aggregate functions in sql
SQL
0 vote109 views1 answer
Print boolean in plsql
SQL
0 vote123 views1 answer
No query unable to fetch row sqlite
SQL
1 vote111 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
5 votes112 views1 answer
Mysql count lines
SQL
0 vote139 views1 answer
How to change the field size of an existing column
SQL