title: Many to Many relationship Schema
body: <p>I have the following tables:</p>
  <h2>Table INFO</h2>
  <pre><code>_id: unique id
  record_id: varchar
  info: varchar
  </code></pre>
  <h2>Table emails</h2>
  <pre><code>_id: unique_id
  record_id: references (INFO.record_id)
  email: varchar
  </code></pre>
  <p>In this scenario, emails can relate to different INFO rows. What would be the better way to create such a table with the proper relationship? Can I create a foreign key on emails pointing to a nonunique id (<code>record_id</code>) on <code>INFO</code>?</p>
  <p>And then how can I query such as I have one row for each INFO row that includes all the emails from the emails table?</p>