/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

0 vote95 views1 answer
Hash not found laravel
PHP
3 votes104 views2 answers
Laravel blade auth check
PHP
0 vote105 views1 answer
Declare variable as global
PHP
3 votes112 views1 answer
Php increase number in file by one
PHP
0 vote126 views2 answers
Value() in laravel
PHP Laravel
0 vote172 views1 answer
Comment ajouter nofollow à un lien spécifique ou à tous les liens WordPress dans the_content
PHP Wordpress
0 vote97 views1 answer
Url() inside laravel config files
PHP
0 vote100 views3 answers
Get category name by id wordpress
PHP
3 votes120 views1 answer
Run laravel cron job on cpanel
PHP Laravel
0 vote129 views2 answers
Wordpress post revisions config
PHP Wordpress