<div>
Hi,<br />
<br />
You're correct, FetchXml does not support Unions.<br />
<br />
However, if you are trying achieve Union on some program, it can be achieved by concatenating the results of 2 different FetchXml query execution.<br />
<br />
If you're trying to achieve it in an SSRS report. It is possible through a hack. <br />
You need to create multiple DataSets. All DataSets should have 1 field common. Which can then be compared and set to get values.<br />
<br />
Follow this link and you should be have what you want on FetchXml Union-<br />
<a href="http://ashishmahajancrm.blogspot.com/2012/04/microsoft-dynamics-crm-2011-develop.html" rel="ugc">http://ashishmahajancrm.blogspot.com/2012/04/microsoft-dynamics-crm-2011-develop.html</a>
</div>


Hi,

You're correct, FetchXml does not support Unions.

However, if you are trying achieve Union on some program, it can be achieved by concatenating the results of 2 different FetchXml query execution.

If you're trying to achieve it in an SSRS report. It is possible through a hack.
You need to create multiple DataSets. All DataSets should have 1 field common. Which can then be compared and set to get values.

Follow this link and you should be have what you want on FetchXml Union-
http://ashishmahajancrm.blogspot.com/2012/04/microsoft-dynamics-crm-2011-develop.html [http://ashishmahajancrm.blogspot.com/2012/04/microsoft-dynamics-crm-2011-develop.html]

<div>
I couldnt figure how to do a Union with that link.
</div>


I couldnt figure how to do a Union with that link.

<div>
<div class="content wysiwyg-content">
Does anyone know how to write a query that can replicate a SQL UNION statement in Fetch XML? I googled this and there were posts saying UNIONS are non-existent in FETCH XML.
</div>
</div>


Does anyone know how to write a query that can replicate a SQL UNION statement in Fetch XML? I googled this and there were posts saying UNIONS are non-existent in FETCH XML.

Fetch XML Unions?

Microsoft Dynamics is a line of enterprise resource planning (ERP) and customer relationship management (CRM) software applications. Dynamics can be used with other Microsoft solutions, such as SharePoint, Yammer, Office 365, Azure and Outlook. Dynamics ERP comprises a group of enterprise-resource-planning products includes Dynamics AX (formerly Axapta), a multi-language, multi-currency enterprise software with business management features for financial, human resources, and operations management; Dynamics GP (formerly Great Plains Software); Dynamics NAV (formerly Navision) for financials, supply chain, and people; Dynamics SL (formerly Solomon IV)for project-driven organizations; Dynamics C5 (formerly Concorde C5) for manufacturing, supply chains, analytics and electronic commerce; and Dynamics CRM.

Microsoft Dynamics

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).