/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

16 votes220 views3 answers
T-SQL Add Column
SQL
1 vote179 views2 answers
Oracle list partitioned tables
SQL
0 vote180 views1 answer
Mysql wsrep ls
SQL
0 vote190 views1 answer
Alter database name script
SQL
1 vote227 views1 answer
Delete dublicate rows sql
SQL
0 vote188 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
2 votes184 views1 answer
Ssh mysql port forwarding
SQL
0 vote178 views1 answer
Sql get guid
SQL
0 vote172 views1 answer
MySql get primary keys of table
SQL
0 vote178 views1 answer
Automatically update database last seen datetime in sql
SQL