/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

1 vote164 views1 answer
Laravel read origanl value before update
PHP
0 vote204 views1 answer
How to get all post fields in wordpress
PHP Wordpress
0 vote174 views2 answers
Yii2 set cookie
PHP
1 vote173 views1 answer
Redirect image attachment pages in Wordpress
PHP
0 vote210 views5 answers
Get recoed between two datetime laravel
PHP
0 vote170 views1 answer
Use php to acces protected csv file
PHP
0 vote176 views1 answer
Laravel request except multiple
PHP
0 vote174 views1 answer
Import local js file laravel
PHP
0 vote174 views1 answer
Regenerate session ID and remove all session data
PHP
0 vote190 views1 answer
Return view('user.profile', ['User' => UserController3::fineOrFail($id)]);
PHP