/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 vote321 views1 answer
Sql server concat null
SQL
4 votes377 views4 answers
Check constraint in ms sql
SQL
0 vote337 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote320 views1 answer
Mysql return column names when table is empty
SQL
0 vote362 views3 answers
Mysql CAST(amount as float)
SQL
3 votes342 views1 answer
Oracle list privileges
SQL
2 votes308 views1 answer
Postgresql drop primary key constraint
SQL
-1 vote297 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote321 views1 answer
Order by in codeigniter query builder
SQL
0 vote324 views1 answer
Not equal to blank in mysql
SQL