title: Join three table codeigniter 4
body: <p>Hi everyone i'am new on codeigniter 4 and currently working on a small project in the project i'am trying to join three tables and display there data in single table.</p>
  <pre><code>Table_1
  id unique_id Name
  1  1111      Sam   
  2  2222      Charlote
  
  Table_2
  id unique_id Name
  1  1212      Jhon 
  2  5151      Alex
  
  Table_3
  id author title
  1  1111   Book_1
  2  5151   Book_2
  3  1111   Book_3
  
  
  Result
  ------------------------
  | No | Author | Title  |
  ------------------------
  | 1  | Sam    | Book_1 |
  | 2  | Alex   | Book_2 |
  | 3  | Sam    | Book_3 |
  ------------------------
  </code></pre>
  <p>I've tried to join with, but not working.</p>
  <pre><code>        $this-&gt;join('Table_1', 'Table_1.unique_id = Table_3.author ');
          $this-&gt;join('Table_2', 'Table_2.unique_id = Table_3.author ');
          $this-&gt;select('Table_1.Name');
          $this-&gt;select('Table_2.Name');
          $this-&gt;select('Table_3.*');
          $this-&gt;orderBy('Table_3.id');
          return  $this-&gt;findAll();
  </code></pre>
  <p>Is there another way to Join them?
  Thank you</p>