我接受了@Nick.McDermaid的建议，并更多地研究了连接引用表。我以前用XML尝试过这个方法，但遇到的问题是我最初没有为链接实体包含别名。因此，民主同盟军没有挑选这些有联系的实体。下面是我的XML示例：

<fetch>
  <entity name="cmc_application">
    <attribute name="cmc_applicationid" />
    <attribute name="cmc_contactid" />
    <attribute name="cmc_applicationname" />
    <attribute name="cmc_applicationperiodid" />
    <attribute name="cmc_applicationsubmitted" />
    <attribute name="cmc_programid" />
    <attribute name="cmc_shiftid" />
    <attribute name="cmcps_applicationenrollmentstatus" />
    <attribute name="cmcps_applicationstudenttype" />
    <attribute name="cmcps_campus" />
    <attribute name="cmcps_haveyoueverbeenconvictedofacrime" />
    <attribute name="cmcps_usextensioncampus" />
    <filter>
      <condition attribute="cmc_applicationid" operator="eq" value="@{item().cmc_applicationid}" />
    </filter>
    <link-entity name="cmc_applicationperiod" from="cmc_applicationperiodid" to="cmc_applicationperiodid" link-type="inner" alias="ap">
      <attribute name="cmc_applicationperiodname" />
    </link-entity>
    <link-entity name="mshied_program" from="mshied_programid" to="cmc_programid" link-type="inner" alias="Pro">
      <attribute name="mshied_name" />
    </link-entity>
    <link-entity name="account" from="accountid" to="cmcps_campus" link-type="outer" alias="camp">
      <attribute name="name" />
    </link-entity>
    <link-entity name="account" from="accountid" to="cmcps_usextensioncampus" link-type="outer" alias="ext">
      <attribute name="name" />
    </link-entity>
    <link-entity name="cmc_studenttype" from="cmc_studenttypeid" to="cmcps_applicationstudenttype" alias="student">
      <attribute name="cmc_studenttypename" />
    </link-entity>
        <link-entity name="cmc_shift" from="cmc_shiftid" to="cmc_shiftid" link-type="inner" alias="shift">
      <attribute name="cmc_shiftname" />
    </link-entity>
  </entity>
</fetch>

字符串