How to combine multiple table results into one using FetchXml

Question

I am using CRM 2013 Online. I want to create an Opportunity object report as shown below:

CampaignCode    Open Opportunity Count  Won Opportunity Count   Lost Opportunity Count
    CC1                    3                       5                       1
    CC2                    0                       2                       3

Here the results are grouped by the "CampaignCode" column, which is the search. Using FetchXml, I can get 3 tables as shown below:

CampaignCode    Open Opportunity Count
    CC1                3        
    CC2                0
CampaignCode    Won Opportunity Count
    CC1                5        
    CC2                2
CampaignCode    Lost Opportunity Count
    CC1                1        
    CC2                3

But I cannot combine these 3 tables into 1. How can I do this?

Answer 1

Why do I know that it is impossible to combine multiple data sets in one table. I will give your question plus, because it interests me too.