/PHP/CodeIgniter/How to use join query in codeigniter

How to use join query in codeigniter

public function getdata(){	

	$this->db->select('*');
	$this->db->from('table1'); // this is first table name
	$this->db->join('table2', 'table2.id = table1.id'); // this is second table name with both table ids
	$query = $this->db->get();
	return $query->result();

	}

Source: wlearnsmart.com

Similar codes

-1 vote214 views3 answers
Codeigniter pagination example
PHP CodeIgniter
0 vote187 views1 answer
Delete Query with Where Condition in Codeigniter
PHP CodeIgniter
0 vote202 views1 answer
Function id codeigniter 3
PHP CodeIgniter
0 vote196 views1 answer
Access config variable in codeigniter controller
PHP CodeIgniter
0 vote196 views1 answer
Codeigniter abort 404
PHP CodeIgniter
1 vote196 views3 answers
Codeigniter store session data
PHP CodeIgniter
3 votes195 views1 answer
Codeigniter form_validation email
PHP CodeIgniter
0 vote201 views1 answer
Codeigniter echo set content type
PHP CodeIgniter
3 votes244 views4 answers
Codeigniter apache remove index.php
PHP CodeIgniter
0 vote194 views1 answer
Return only one column data from table in codeigniter
PHP CodeIgniter