Suppose I have documents Account :{ account_id : 1, account_name : "kontu "} Payment:{ id: 1, account_id :1, amount :2 }, Payment :{ id: 2, account_id :1, amount :23} How to write query so that i can get data given below: Account :{ account_id : 1, account_name : "kontu’ Payments :[ …

Join Two documents

binh.le January 13, 2019, 4:41pm 3

Hi vsr,
Can you explain why you have a predicate for a.type=‘accounts’, but not p.type = ‘payments’?

Topic		Replies	Views
N1QL Three Document join SQL++ query	3	702	May 2, 2019
Joining two documents SQL++	2	1866	September 14, 2016
How to join more two document in same bucket? SQL++ query , n1ql	13	1508	April 20, 2018
Join with array in different document Couchbase Server n1ql	2	706	December 1, 2019
N1ql on two different documents SQL++	2	705	October 31, 2018