In Cosmos DB two documents:
- first_document (List type)
- second_document
First query to get data from first_document passing "abcd" as param
input param: abcd
Query 1:
select c.first_name, c.second_name
from c
IN t.first_document
where c.first_document_code = abcd
Second query takes first_name from above query as input param.
Query 2:
select *
from c.second_document
where c.second_document_code = "first_name"
this 2nd query will return list as response.
how to join these queries into single query?
