/PHP/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

22 votes362 views2 answers
Where status is null sql in laravel
PHP
-1 vote369 views2 answers
Submit form and send email in php
PHP
28 votes337 views6 answers
Laravel drop foreign key
PHP
-2 votes398 views1 answer
Laravel add user
PHP Laravel
1 vote345 views5 answers
Get field acf
PHP
0 vote331 views1 answer
Add character after x characters in php
PHP
1 vote335 views1 answer
Why job laravel do not worl
PHP
5 votes383 views5 answers
Laravel composer update
PHP
77 votes358 views6 answers
Php substr
PHP
4 votes404 views2 answers
Laravel please provide a valid cache path
PHP Laravel