title: Join 3 Tables DB
body: <p>I have 3 tables: <code>CUSTOMERS</code>, <code>REGISTRATION</code> and <code>TUITION</code> table. </p>
  
  <p>The <code>Registration</code> table has foreign key:</p>
  
  <pre><code>ID_CLIENTES (FK)
  ID_AULAS (FK)
  </code></pre>
  
  <p>And primary key:</p>
  
  <pre><code>ID_INSCRICAO
  </code></pre>
  
  <p>The objective is to create a select, but which has all the tables according to the inscriptions ie (table.attribute):</p>
  
  <pre><code>INSCRICAO.ID_INSCRICAO | INSCRICAO.DATA | CLIENTES.CNOME | AULAS.ANOME | AULAS.DATA | AULAS.VAGAS |
  </code></pre>
  
  <p>Have tried using the model:</p>
  
  <pre><code>SELECT INSCRICAO.ID_INSCRICAO, 
    INSCRICAO.DATA, 
    CLIENTES.CNOME, 
    AULAS.ANOME,
    AULAS.DATA,
    AULAS.VAGAS
  FROM table1 INSCRICAO
  left outer join table2 CLIENTES 
     on INSCRICAO.ID_INSCRICAO=CLIENTES.ID_CLIENTES
  left outer join table3 AULAS 
     on AULAS.ID_AULA = INSCRICAO.ID_INSCRICAO;
  </code></pre>
  
  <p>That gives me error or multiplies the rows of tables, and the goal was to have the same number of records that the table entries </p>
  
  <p>Can anyone help? </p>