Hi all...

I am relatively new to mysql. I'm currently working on a real estate web project and have set up the following database table outline:

properties
propID
propName
propAddress

languages
langID
langName

propDes (Text description of property)
propDesID
propDesText
propID(from properties table)
langID(from languages table)

propAm (List of Property Amenities)
propAmID
propAmText
propID
langID


Now what I would like to do -- with one query string -- is to retrieve the following fields:

propName
propAddress
propDesText
propAmText

for the a specified langID and propID.

Any help?

Thanks a bunch!