I have lost my mind on this one.

I have used the inner join successfully on a portion of my site but I've run into a bit of a snag.

Tables & Fields
PropertyInfo - Contains property information
     [u]PropertyID</u>, [u]ContactID</u>, Address, Price.....

ContactInfo - Contains Contact Information which a person could be the contact for more than one property
     [u]ContactID</u>, ContactName, ContactPhone...

PropFeatures - Contains property features which can contain multiple features for each one property
     [u]PropertyID</u>, Feature, FeautreDesc...

I have been able to create the INNER JOIN for PropertyInfo & ContactInfo as shown below.

"SELECT PropertyInfo.PropertyID, PropertyInfo.ContactID, ContactInfo.ContactID, " & _
"PropertyInfo.MLSNo, PropertyInfo.StreetAddress, PropertyInfo.UnitNumber, PropertyInfo.City, PropertyInfo.State, " &_
"ContactInfo.ContactName, ContactInfo.ContactPhone1, ContactInfo.ContactPhone2, ContactInfo.ContactEmail, " & _
" FROM ContactInfo INNER JOIN PropertyInfo ON ContactInfo.ContactID = PropertyInfo.ContactID " & _
"WHERE (PropertyInfo.PropertyID LIKE '" & strPropertyID & "')"

Now I need to add the PropFeatures Table to the Query. When I do, it repeats the Property Information for each Feature in PropFeatures.

Help...

[email protected]

Well when you join it that is exactly what is suppose to happen. So the question is, what do you want to show from the PropFeatures table?

What I need it to do is to list the property once and the features that belong to that property.

PropID StreetAddress Features
12345 123 Any Street Pool
                            Washer & Dryer
                            Fireplace
                            Fenced Yard

Never Mind - I figured it out.

It wasn't the query but where I had the Whild...Wend