/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 vote174 views1 answer
SQL Query to delete all the tables in a database
SQL
0 vote201 views1 answer
Get initials name in sql
SQL
0 vote160 views1 answer
Flexible search query delete table
SQL
7 votes163 views2 answers
3rd height salary sql
SQL
0 vote193 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
1 vote159 views1 answer
Get all db sizes in mysql server
SQL
0 vote179 views1 answer
Sqlite version check
SQL
-1 vote156 views1 answer
Insert results of a stored procedure into a temporary table
SQL
0 vote171 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote179 views1 answer
Check if mysql db is used
SQL