title: Select all from one table and if exist take the more details on another table
body: <p>I have two different tables, both there is similar unique keys so I can link both using this ID.</p>
  
  <p>On the first table I have 1287 people registered and on the second table I have just 786 people registered.</p>
  
  <p>Then, I want to show 1287 people of the first table and if exist this same ID on the other table 786 show more information about this subscribed..</p>
  
  <p>I don't know if I could explain very well, but I have no idea how start it.</p>
  
  <pre><code>SELECT * FROM oficinas_inscritos, oficina_pesquisa WHERE oficina_pesquisa.cpf = oficinas_inscritos.cpf
  </code></pre>