Using Join for Where clause

SQL++
6

My document key for zone is like “Zone_1234”
Here are a few sample documents :

Zone_1234:
{
“id”: “1234”,
“zoneName”: “WelcomeBanner”,
“registrationId”: “zone1”,
“description”: “zone”,
“type”:“zone”
}

Rule_ZsOwNdShBGgGmyeJ:
{
“id”: “ZsOwNdShBGgGmyeJ”,
“channelTenantId”: “0oLaKIYx”,
“orgId”: “abcd1234”,
“priority”: 1,
“name”: “RuleAbc”,
“zoneId”: “1234”,
“type”:“rule”
}