/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

8 votes144 views1 answer
Sql remove leading spaces
SQL
3 votes102 views1 answer
System.debug apex
SQL
4 votes139 views6 answers
Sql select statement
SQL
0 vote206 views1 answer
Mysql update table from select on another table
SQL
0 vote132 views1 answer
The local psql command could not be located
SQL
0 vote158 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote152 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote170 views1 answer
How to check database engine in mysql
SQL
0 vote182 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote172 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL