/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

2 votes369 views3 answers
Postgres json to string
SQL
0 vote351 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote402 views1 answer
Split first name and last name in sql
SQL
3 votes402 views1 answer
Mysql cli connect with password
SQL
1 vote357 views1 answer
Change default maximum runtime mariadb from phpmyadmin
SQL
0 vote345 views1 answer
Renombrar tabla mysql
SQL
0 vote306 views1 answer
Mariadb LOAD DATA INFILE
SQL
10 votes325 views2 answers
Sql rtrim
SQL
0 vote356 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote398 views1 answer
How to add auto increment primary key
SQL