title: Inner Joining two tables based on all "Key/Value" Pairs matching exactly
body: <p>Lets say I have two tables - Person and Clothes and both of these tables have associated Key/Value tables which store attributes about a Person and an item of Clothing.</p>
  
  <p>A joined version of Person to Attributes might look like:</p>
  
  <pre><code> PersonID | AttributeKey | AttributeValue
      1          'Age'          '20'
      1          'Size'         'Large'
      2          'Age'          '20'
  </code></pre>
  
  <p>A joined version of Clothing to Attributes might look like:</p>
  
  <pre><code> ClothingID | AttributeKey | AttributeValue
      99          'Age'          '20'
      99          'Color'        'Blue'
      60          'Age'          '20'
  </code></pre>
  
  <p>Given a specifc Piece of clothing I want to find the Person entries which match EXACTLY ALL pairs of Attributes. For example, given ClothingID 60 I want to get ONLY PersonID 2 even though PersonID 1 did have a matching AGE but it had extra attributes. And basically the opposite has the same effect.</p>
  
  <p>Given Clothing 99 I would expect NO results since no Person entries have a Color attribute.</p>
  
  <p>An INNER JOIN obviously gives me the Attributes of Clothing which matching specific Attributes of People. But I want to only return rows where ALL possible matches did indeed match and throw out the others if there were extra. An OUTER JOIN will give me NULL values for ones that match but how I detect this and throw out all Person rows if 1 row had NULLS?</p>