title: Get value from another table
body: <p>I have 2 tables like this:</p>
  
  <p>Table1
      doc_id (1)
      doc_folder (1010)
      doc_title (invoice 2020)</p>
  
  <p>Table2
      file_id (1)
      file_doc_id (1)
      file_name (invoice.pdf)</p>
  
  <p>Now, i perform a query to get all titles:</p>
  
  <pre><code>    SELECT * FROM Table1
      WHERE doc_folder='1010'
  </code></pre>
  
  <p>I'm like to get a file name from Table2 and have result like this:</p>
  
  <pre><code>FOLDER | TITLE     | FILE NAME 
  1010     invoice     invoice.pdf
  </code></pre>
  
  <p>How to get filename from Table2</p>
  
  <p>TKS ALL</p>