As we’ve covered pretty extensively on the blog lately, Microsoft Dynamics CRM 2013 has a ton of new great features. One of the things we haven’t covered yet is the new ability to perform left outer join queries using FetchXML. So let’s dive in!


Below you’ll see an account record that doesn’t have any cases.

Left Join Using FetchXML
Account with no associated cases.

To query for accounts that don’t have cases, you can use the following FetchXML query:

Left outer join query between accounts and cases (incident).

The two main pieces to specify are the link-type, which is part of the link-entity, and the operator of the condition of a filter. Set the link-type to outer and the operator to null.

Below is a screenshot of the results when the RetrieveMultiple request is executed.

Result from executing left join.

In order to use this left join inside CRM 2013, use the SavedQuery entity to create a view.

Use SavedQuery to create the view.

Once executed, you can now see this left join view.

View of accounts with no cases.

There you have it—that’s how to perform a left join using FetchXML and display results in  Microsoft Dynamics CRM 2013!

Was this helpful? Keep checking back for more blogs covering Dynamics CRM 2013 features, and check out our events page for upcoming CRM 2013 educational webinars.

Happy CRM’ing!

Avatar for Joe D365

Joe D365

Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.