best way to query multiple tables

[coolphpdude]

hey people

 

could somebody tell me what is the best way to query multiple tables.

 

For example I am doing a website based on an estate agents for my course. A Property will have numerous features. I'll have a table in the following format

 

ID    -      feature_id    -    feature

1      -      f1                -    Double garage

2      -      f2                -    double glazing

3      -      f3                -    front garden

4      -      f4                -    back garden

 

 

something along those lines anyway! well basically what i want to do is add a property to a table then add features of that particular property. so maybe a link table between the 2, i.e: (property 1 has double glazing)

 

property    -    feature

p1            -    f2

 

I'll have a couple of different tables that are relevant to things that the property includes. what i want to know is the best way to query that database so that i can out from all tables anything that is relevant to property 1.

 

hope this makes sense cos ive actually confused myself tryin to explain this!!

 

Cheers

[Mark Baker]

The best place to lear is to read the section of your database documentation on joins, particularly inner and outer joins.