/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

4 votes109 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
1 vote108 views1 answer
Drop table if exists oracle
SQL
0 vote128 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
0 vote117 views1 answer
Insert into select with group by
SQL
0 vote125 views2 answers
Athena drop partition
SQL
3 votes106 views2 answers
Oracle sql truncate table
SQL
0 vote122 views1 answer
Login failed for user sql server
SQL
-1 vote115 views1 answer
Add column alter table default value
SQL
4 votes106 views3 answers
Create database in mySQL
SQL
2 votes117 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL