/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 vote245 views1 answer
Mysql gone away error in php
PHP
-1 vote256 views2 answers
Php elvis operator
PHP
10 votes281 views4 answers
Print last query laravel
PHP Laravel
0 vote265 views2 answers
Woocommerce_variation_option_name on frontend
PHP
4 votes245 views2 answers
Laravel DB wherein
PHP
0 vote232 views1 answer
Ipv6 pregmatch
PHP
0 vote229 views1 answer
Laravel simple
PHP
1 vote308 views1 answer
Changer le logo Admin WordPress
PHP
2 votes240 views1 answer
Laravel set appends
PHP
1 vote246 views2 answers
Woocommerce cart button shortcode
PHP