title: Show data that is not in other table with join codeigniter
body: <p>I have 2 tables, I try to join to combine the 2 tables with codeigniter, but when I create query join there is data that does not appear because the data is not in the other table again, how can I solve this problem ??</p>
  
  <pre><code>tbl_fruit
  _______________
  | id |  fruit | 
  |----|--------|
  | 0  | manggo | 
  | 1  | apple  | 
  | 2  | banana | 
  | 3  | orange | 
  | 4  | avocado| 
  
  tbl_proc
  _______________
  | id |  proc  | 
  |----|--------|
  | 0  | juice  | 
  | 1  | blend  | 
  | 2  | shake  | 
  
  tbl_master
  ____________________________________
  | id | id_fruit | id_proc | client  |
  |----|----------|---------|---------|
  |  0 |     2    |         |         | //How display on join
  |  1 |     1    |    2    | nana    |
  |  2 |     3    |    2    | george  |
  |  3 |     4    |    0    | smith   |
  |  4 |     0    |         | billy   | //How display on join
  |  5 |     2    |    1    | Jack    |
  
  tbl_result
  ----------------------------------------
  | no | name fruit | name proc | client |
  |----|------------|-----------|--------|
  |  0 |  apple     | shake     | nana   |
  |  1 |  orange    | shake     | george |
  |  2 |  avocado   | juice     | smith  |
  |  3 |  banana    | blend     | smith  |    
  
      $query = $this-&gt;db-&gt;select('*')
                        -&gt;from('tb_result')
                        -&gt;join('tb_fruit', 'tb_fruit.id = tb_result.id_fruit')
                        -&gt;join('tb_proc', 'tb_proc.id = tb_result.id_proc')
                        -&gt;get();
      return $query-&gt;result(); 
  </code></pre>
  
  <p>how to display data on tbl_master that does not have data in other tables but appears in the table in the join?</p>