title: Adding some logic to SQL query
body: <p>First of all I'm really not that great at sql, with that said, onwards to the question:</p>
  
  <p>Lets say I have a table called Abilities.
  In this example Abilities has a ID, PersonID, Text.</p>
  
  <p>Lets say I do a search where I specify that I want to distinct list every person that has the ability to 'Fly', 'Drive', 'Sing' but do NOT have the ability to 'Fight', 'Skateboard'</p>
  
  <p>Is there anyway to write such a query which in the end will only return the rows that match my above statement? The table and it's contents is purely fictional I might add, hence the wierdness :P</p>
  
  <p>I would really appreciate help with this as it's for a rather complex search utility for a database.</p>
  
  <p>Thanks</p>