title: I can't select two table in codeligniter
body: <p>I have a challenge for a job and my mission is to perform a CRUD using codeigniter. And in this challenge, I have to make a listing of two MYSQL tables, one with the name &quot;deliverer&quot; and the other &quot;address&quot;.</p>
  <p>The problem is that I am not able to make the connection in the database with the two tables. I'll show you how my Controller and my Model are.</p>
  <p>Model:</p>
  <pre><code>public function SelecionaTodos() {
  
      $retorno = $this-&gt;db-&gt;get('entregador',100);  *I NEED TO CONNECT THE DELIVERY TABLE AND ADDRESS *
  
      return $retorno-&gt;result();
  
  }
  </code></pre>
  <p>Controller:</p>
  <p>public function index() {</p>
  <pre><code>    $this-&gt;load-&gt;model('EntregadorModel');
  
      $tabela = $this-&gt;EntregadorModel-&gt;SelecionaTodos();
  
      $dados = array(
          'titulo' =&gt; 'Lista de Entregadores',
          'tabela' =&gt; $tabela,
          'pagina' =&gt; 'entregador/index.php'
      );
  
      $this-&gt;load-&gt;view('index',$dados);
  }
  </code></pre>