/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 vote257 views1 answer
Order by monthly in sql
SQL
0 vote268 views4 answers
Forenkey code alchemy sql
SQL
1 vote295 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
0 vote261 views1 answer
Add alternate add column sql
SQL
13 votes284 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote274 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
3 votes256 views1 answer
Difference sql vs mysql
SQL
0 vote279 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
4 votes268 views1 answer
Select first and last row sql
SQL
0 vote295 views1 answer
Learnxinyminutes sql
SQL