Count for many-to-many relationship
You are close.  In SQL Server, you have to GROUP BY before you state HAVING.  Personally, I would do something like this

    SELECT COUNT(id) Surveys_w_2_LandOwners
    FROM surveys s
        JOIN 
        (
            SELECT COUNT(1),property_id
            FROM owners_properties
            GROUP BY property_id
            HAVING COUNT(1) &gt; 1
        ) p ON p.property_id=s.property_id