Multiple Inner Joins
I currently have three tables joined and working.
FROM ContactInfo INNER JOIN
(PropertyInfo INNER JOIN PropFeatures
ON PropertyInfo.PropertyID = PropFeatures.PropertyID)
ON ContactInfo.ContactID = PropertyInfo.ContactID
My problem comes when I need to add a fourth table.
OpenHouse.PropertyID
Where do I add this?
Help.
|