左加入FetchXml吗？ [英] Left join in FetchXml?

问题描述

如何使用FetchXml进行左联接？

请考虑以下简单的SQL查询：

 从人员
中选择person.name，address.city加入person.addressid = address.addressid 
   
 
 
如何使用FetchXml完成类似的简单操作？ 
当前，我的FetchXml查询如下所示：
 < fetch mapping ='logical'> 
<实体名称=人> 
< attribute name =名称 /> 
< link-entity name ='address'从='addressid'到='addressid'> 
<属性名称=城市 /> 
< / link-entity> 
< / entity> 
< / fetch> 
  
 
 
解决方案
更新您的< link -entity> 像这样：
 <链接实体名称='地址'from =' addressid'to ='addressid'link-type ='outer'> 
  
 
How do i do a left join using FetchXml?

Consider a simple SQL query like the following:
select person.name, address.city from person
left join address on person.addressid = address.addressid
How would something simple like this be done using FetchXml?
Currently my FetchXml query looks like the following:
<fetch mapping='logical'>
  <entity name='person'>
    <attribute name='name' />
    <link-entity name='address' from='addressid' to='addressid'>
      <attribute name='city' />
    </link-entity>
  </entity>
</fetch>

解决方案
Update your <link-entity> like so:
<link-entity name='address' from='addressid' to='addressid' link-type='outer'>


                        
这篇关于左加入FetchXml吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！