/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

5 votes272 views3 answers
Create function in postgresql
SQL
1 vote208 views1 answer
Rows to comma separated values in mssql
SQL
1 vote222 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
3 votes234 views2 answers
Sqlite show table definition
SQL
2 votes203 views1 answer
Sql column values comma separated
SQL
4 votes193 views2 answers
Postgresql reset sequence
SQL
0 vote219 views2 answers
Mysql missin expression near on
SQL
1 vote238 views1 answer
Epoch time converter in snowflake
SQL
0 vote196 views1 answer
Greater than or equal to symbol in postgres
SQL
0 vote195 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL