Left join in FetchXml?

Question

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>

score 11 · Accepted Answer · answered Jul 10 '10 at 15:17

11

Update your <link-entity> like so:

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

answered Jul 10 '10 at 15:17

Matt

4,656
1
22
32

So -- implied in this is that `link-type='outer'` behaves NOT like a full outer join, but like a left outer join ? – Don Cheadle Aug 21 '15 at 20:47
Correct, it acts as a left outer join. – Matt Aug 21 '15 at 23:55

Left join in FetchXml?

1 Answers1

Linked