title: CODEIGNITER how to join 3 tables to be used in multilogin user level
body: <p><a href="https://i.stack.imgur.com/WpuxK.png" rel="nofollow noreferrer">here is my database schema</a>
  good day everyone i would like to ask how to join 3 tables in codeigniter. my aim is i want to join the tables for the login. i can login with the student but when i login with the instructor i cannot because i dont know how to join the three tables .</p>
  <pre><code>        $this-&gt;db-&gt;select('*');
          $this-&gt;db-&gt;from('tbl_users');
          $this-&gt;db-&gt;join('tbl_student', 'tbl_student.student_id = tbl_users.user_id');
          $this-&gt;db-&gt;where('idnumber', $idnumber);  
          $this-&gt;db-&gt;where('password', $password);
  </code></pre>