/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 vote246 views1 answer
Psr/log is locked to version 2.0.0 and an update of this package was not requested. - psr/log 2.0.0 requires php >=8.0.0 -> your php version (7.4.26) does not satisfy that requirement.
PHP
0 vote228 views6 answers
For
PHP
1 vote235 views1 answer
Get the content of a specific page (by ID)
PHP
0 vote266 views1 answer
Wordpress plugin functions exist
PHP Wordpress
0 vote239 views1 answer
Php input time validation
PHP
24 votes226 views4 answers
Laravel query not null
PHP Laravel
8 votes164 views1 answer
Last query in laravel
PHP Laravel
0 vote241 views1 answer
Php binary to base64
PHP
2 votes247 views2 answers
Php header location not working
PHP
1 vote184 views1 answer
Aws sdk php
PHP