Take the 2-minute tour ×  I am trying to figure out a way to
query a property feature lookup table.  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.
pid - primary key     other property details      fid - primary
key      id - primary key     pid - foreign key (Property)
fid - foreign key (Feature)  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?  Thanks for the help and insight.
share|improve this question You can actually drop the "id"
column on Property_Feature t