Trying to Join data from 2 tables using the ID

SQL++
,
1

I want to get data from another bucket using the ID inside a document

The query I’m trying to execute:

SELECT meta().id,`docId`,`createdAt`,`updatedAt`,`data` FROM sales AS ccc 
LET contact = (SELECT meta().id,`docId`,`createdAt`,`updatedAt`,`data` FROM contacts AS bbb USE KEYS [ccc.contactId])
WHERE  status = 'active'   LIMIT 10 OFFSET 0

Source doc:

{
"status": "active",
"data": {
      "billingAddress": null,
      "contactId": "1b529239ea294da687559e1464a8c5a8",
      "count": 1,
      "currency": "USD"
}
}

The doc I want to get "1b529239ea294da687559e1464a8c5a8",

{
"id" : "1b529239ea294da687559e1464a8c5a8"
"status": "active",
 "data" : {
           "name": "SpaceX", "location": {}
     } 
}

The query response I’m trying to get:

{
"status": "active",
"data": {
      "billingAddress": null,
      "contactId": "1b529239ea294da687559e1464a8c5a8",
      "contact": { "data": { "name": "SpaceX"}  }, // *trying to the contact in a contact var by selecting the name*
      "count": 1,
      "currency": "USD"
}
}
2 
SELECT meta().id,`docId`,`createdAt`,`updatedAt`,`data`, contact  
FROM sales AS ccc 
LET contact = (SELECT {bbb.data.name} AS data
             FROM contacts AS bbb USE KEYS ccc.contactId)[0]
WHERE  status = 'active'  
 LIMIT 10 OFFSET 0
3

This works but the result is

[
  {
    "contact": {
      "data": {
        "name": "Myrilla Eccleshare"
      }
    },
    "createdAt": "Wed Jun 17 2020 00:33:47 GMT+0300",
    "data": {
     .....
      "count": 2,
      "currency": "USD",
      "customerId": ""
    }
  }
]

Is there any way I can add contact inside the data and not as a separate object?

[
    "createdAt": "Wed Jun 17 2020 00:33:47 GMT+0300",
    "data": {
     .....
     "contact": {
      "data": {
        "name": "Myrilla Eccleshare"
      },
      "count": 2,
      "currency": "USD",
      "customerId": ""
    }
  }
]
`
4

OBJECT_ADD(data,“contact”,contact) AS data