/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

1 vote264 views1 answer
Truncate table in postgresql and reset id
SQL
0 vote163 views1 answer
How to order result of subquery in select
SQL
3 votes168 views1 answer
Select nextval from sequence sql
SQL
0 vote192 views1 answer
Mysql show create db
SQL
1 vote168 views3 answers
Read all columns of a table sql
SQL
0 vote160 views1 answer
Power query case when
SQL
3 votes311 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
6 votes154 views1 answer
Oracle rank() over (partition)
SQL
0 vote197 views1 answer
Postgres get database encoding
SQL
10 votes175 views2 answers
Show tables in schema oracle
SQL