I have below json
1)
"Cronresult|12":{
      "_type": "DailyCampaignUsage",
      "bids": [
        {
          "clicks": 3,
        }
      ],
      "campaignId": 2614,
}
2).a
"campaign|2614"{
"country": 14,
 "_id": 2614,
}
2).b
"campaign|31"{
"country": 12,
 "_id": 31,
}
I am trying below query
SELECT Campaign.country,count(DISTINCT Campaign._id) campaigns,
SUM(ARRAY_SUM(DailyCampaignUsage.`statistics`[*].clicks)) clicks,
FROM Inheritx DailyCampaignUsage  
JOIN Inheritx Campaign ON KEYS ('Campaign|'||TOSTRING(DailyCampaignUsage.campaignId))       
where  DailyCampaignUsage._type='DailyCampaignUsage'
it is bring below result
{
    "country": "14",
    "campaigns": 2614,
    "clicks":3 
    }
BUT
I need output like below
    {
   "country": "12",
   "campaigns": 31,
   "clicks":0
    },
    {
    "country": "14",
    "campaigns": 2614,
    "clicks":3 
    },
I need to here RIGHT JOIN like MySQL.
Can I do it here in N1QL ??
if Yes then how can I do it ??