Left join in FetchXml?

Luke Baulch picture Luke Baulch · Jul 10, 2010 · Viewed 10.2k times · Source

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>

Answer

Matt picture Matt · Jul 10, 2010

Update your <link-entity> like so:

<link-entity name='address' from='addressid' to='addressid' link-type='outer'>