I have created the below view:
THe Fetch XML is:
-<fetch distinct="true" mapping="logical" output-format="xml-platform" version="1.0">
-<entity name="contact">
<attribute name="fullname"/>
<attribute name="telephone1"/>
<attribute name="contactid"/>
<attribute name="parentcustomerid"/>
<order descending="false" attribute="fullname"/>
-<link-entity name="activityparty" alias="am" link-type="inner" to="contactid" from="partyid">
<link-entity name="msfp_surveyresponse" alias="an" link-type="inner" to="activityid" from="activityid"/>
</link-entity>
</entity>
</fetch>
I can't figure out what entity the 2nd join is referring to. activityid from surveyresponse is linked to activityid from what other entity?
