title: Best Practice to querying a Lookup table
body: <p>I am trying to figure out a way to query a property feature lookup table.</p>
  
  <p>I have a property table that contains rental property information (address, rent, deposit, # of bedrooms, etc.) along with another table (Property_Feature) that represents the features of this property (pool, air conditioning, laundry on-site, etc.). The features themselves are defined in yet another table labeled Feature.</p>
  
  <pre><code>Property
      pid - primary key
      other property details
  
  Feature
      fid - primary key
      name
      value
  
  Property_Feature
      id - primary key
      pid - foreign key (Property)
      fid - foreign key (Feature)
  </code></pre>
  
  <p>Let say someone wants to search for property that has air conditioning, and a pool and laundry on-site. How do you query the Property_Feature table for multiple features for the same property if each row only represents one feature? What would the SQL query look like? Is this possible? Is there a better solution?</p>
  
  <p>Thanks for the help and insight.</p>