title: 3 way relationship in SQL?
body: <p>Say that I have an object named <code>person</code> which has (name, address, phone_number) as its attributions and an object named <code>dog</code> which has (ID, year_of_birth, breed). Then I have a relationship between the two objects named <code>owner</code>. <code>Owner</code> has the following attributions: (owner_id, pet_id). </p>
  
  <p>On an E-R diagram <code>owner</code> would be a triangle connecting <code>dog</code> and <code>person</code> which are both rectangular. I'm giving this info just so you understand the relationship. my goal is to list the <code>dogs</code> ID's who's owners are from France.</p>
  
  <p>I've tried the following an dozens of different combinations like this:</p>
  
  <pre><code>select id from owner where address = 'France';
  </code></pre>