title: Join two SQLite tables in Android application
body: <p>I need to join two tables into a relational table. I know that I can do this with inner join but I don't know how to start.</p>
  
  <pre><code>TABLE_SOCIO
  -----------------
  -id
  
  -name
  
  -phone
  
  -email
  
  TABLE QUOTA
  -----------------
  -id
  
  -name
  
  -description
  
  -value
  </code></pre>
  
  <p>Now I need to join this two in on unique table by the id's of each.</p>
  
  <pre><code>RELATIONAL TABLE
  -----------------
  -id_Quota
  
  -id_Socio
  </code></pre>
  
  <p>I have one id_Quota to n id's_Socio. It's a relation 1-n. I have an array list with the set of id_Socio that I need to save in relational table with only one id_Quota.</p>
  
  <p>Any ideas? How I can start with inner join? Foreign key it's need?
  Any example?</p>