Codeigniter Select data from multiple tables

Question

i have been using this model for getting datafrom only one table

function model_employee_all()
 {
  $this->load->database();
  $query = $this->db->get('mytable1');
  return $query->result();
 }

How should i configure it to get data from multiple tables such as mytable1 and mytable2, Is there any way to use joins...

Thanks.

saravankg · Accepted Answer · 2014-10-23 09:50:55Z

1

$this->db->join

saravankg

9111 gold badge11 silver badges22 bronze badges

answered May 8, 2012 at 5:49

Mohit Bumb

2,4935 gold badges33 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1