title: SQL - match records from one table to another table based on several columns
body: <p>I have two tables:<br>
  tblhobby  </p>
  
  <pre><code>   +-------+-------+-------+-------+  
     | name  |hobby1 |hobby2 |hobby3 |  
     +-------+-------+-------+-------+   
     | kris  | ball  | swim  | dance |  
     | james | eat   | sing  | sleep |  
     | amy   | swim  | eat   | watch |  
     +-------+-------+-------+-------+
  </code></pre>
  
  <p>tblavailable_hobby</p>
  
  <pre><code>+----------------+ 
  | available_hobby|
  +----------------+
  | ball           | 
  | dance          | 
  | swim           | 
  | eat            | 
  | watch          | 
  +----------------+ 
  </code></pre>
  
  <p>the sql query should take all the columns in tblhobby and match it with tblavailable_hobby.  If all the hobbies match to the available_hobby, then the person is selected</p>
  
  <p>the query should produce</p>
  
  <pre><code>+--------+ 
  | name   |
  +--------+
  | kris   | 
  | amy    | 
  +--------+
  </code></pre>
  
  <p>Please help</p>
  
  <p>Thanks for the answers. I have inherited this database and not able to normalize it at the moment.  however, I would like to add another twist to the question.  Suppose:</p>
  
  <pre><code>   +-------+-------+-------+-------+  
     | name  |hobby1 |hobby2 |hobby3 |  
     +-------+-------+-------+-------+   
     | kris  | ball  | swim  | dance |  
     | james | eat   | sing  | sleep |  
     | amy   | swim  | eat   | watch | 
     | brad  | ball  |       | dance |
     +-------+-------+-------+-------+
  </code></pre>
  
  <p>I would like to get </p>
  
  <pre><code>+--------+ 
  | name   |
  +--------+
  | kris   | 
  | amy    | 
  | brad   |
  +--------+
  </code></pre>
  
  <p>how would i go about with it?</p>