title: How to make IN condition check for set values
body: <p>Basically I have two tables</p>
  
  <pre><code>MY_CHARACTER:
   _________________________________________________
  | char_ID |   char_name | char_class | char_rank |
  |------------------------------------------------|
  |    1    |   Aragorn   |  Fighter   |     99    |
  |    2    |   Legolas   |  Archer    |     90    |
  |    3    |   Smeagle   |  Spy       |     20    |
  |________________________________________________|
  </code></pre>
  
  <p>and</p>
  
  <pre><code>EQUIPMENT:
       _________________________________________________
      | equip_ID | equip_name  | equip_owner | required  |
      |--------------------------------------------------|
      |    1    | The one ring |     3       |     99    |
      |    2    | Longsword    |     1       |     90    |
      |    3    | Waistcloth   |     3       |     10    |
      |    4    | Nazguls Mask |     2       |     95    |
      |__________________________________________________|
  </code></pre>
  
  <p>Now what I want is to make a select command using IN condition, which will give me list of equipments that the characters are not eligible to use. So in this very example, it would be Smeagle being ineligible to wear the one ring and Legolas unable to wield the nazguls mask. </p>
  
  <p>My command looks something like this</p>
  
  <pre><code>SELECT equip_name, equip_owner, required
  FROM EQUIPMENT WHERE required IN (SELECT char_rank MY_CHARACTER);
  </code></pre>
  
  <p>Now this will only print out the equipment where required=char_rank however i want to print out a select, where required equipment level is higher than char_rank instead. Any idea how? Ideally using the IN condition.</p>
  
  <p><strong>EDIT</strong>: To clear out confusion regarding where I want, basically what my command does right now is it checks if <code>EQUIPMENT.required=MY_CHARACTER.char_rank</code> what I want instead is that it checks <code>EQUIPMENT.required&gt;MY_CHARACTER.char_rank</code></p>