/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

0 vote495 views1 answer
How to make core controller codeigniter 3 more than 1
PHP CodeIgniter
4 votes411 views2 answers
Codeigniter 3 limit
PHP CodeIgniter
1 vote366 views1 answer
Codeigniter distinct
PHP CodeIgniter
0 vote392 views1 answer
Codeigniter sms send
PHP CodeIgniter
0 vote376 views1 answer
Access config variable in codeigniter controller
PHP CodeIgniter
0 vote392 views1 answer
Applying multiple order by in codeigniter
PHP CodeIgniter
-2 votes342 views3 answers
Inner join codeigniter
PHP CodeIgniter
0 vote407 views1 answer
Codeigniter 3 session not working after some time
PHP CodeIgniter
0 vote362 views1 answer
Codeigniter table list
PHP CodeIgniter
0 vote346 views1 answer
Time zone set in codeigniter
PHP CodeIgniter