title: SQL query issue for a many to many relationship
body: <p>I have the following table structure:</p>
  
  <p>Table <code>Sailor</code>:</p>
  
  <pre><code>sid    sname
  -------------------
  22     Dustin
  29     Brutus
  31     Luber 
  32     John
  </code></pre>
  
  <p>Table <code>Boat</code>: </p>
  
  <pre><code>bid    bname
  -------------------
  101    Pirate
  102    Pirate
  103    Marine
  </code></pre>
  
  <p>Table <code>Reserve</code>:</p>
  
  <pre><code>bid   sid   day
  ------------------------------
  101   22    10/10/98
  102   22    10/10/98
  103   22    10/8/98
  103   31    10/7/98
  102   29    9/8/98 
  103   32    9/8/98
  </code></pre>
  
  <p>The result expected is: find names of all sailors who have reserved all boats called <code>Pirate</code>.</p>
  
  <p>Basically, I need to query all the sailors name who have reserved boat called <code>Pirate</code>.</p>
  
  <p>The only issue is that in table boat I have 2 column that has bname as Pirate and their bid are different.</p>
  
  <p>Any idea how to achieve it with the query?</p>