Hi Guys!!! Aloha! I have 3 document type in one bucket and want to join them Here is my document { type: student, studentId:00001, name: John Doe , } { type: grades, studentId:00001, grade: 80 } { type:payment, studentId:00001, amount: $80000 } How can I join the three documents u…

N1QL Multiple joins

vsr1 September 18, 2018, 12:30pm 2

If you are using 5.5 you can use ANSI JOIN
Otherwise can you update post with document key, so that will know if any relation is present or not.

Topic		Replies	Views
Is it possible put Joins on multiple document types in Same bucket SQL++ n1ql	6	3434	November 27, 2015
N1ql join query issue SQL++	2	3198	July 26, 2018
JOIN 5 documents with 1 foreign key SQL++ n1ql	3	1932	September 25, 2018
How to join more two document in same bucket? SQL++ query , n1ql	13	1412	April 20, 2018
N1QL Three Document join SQL++ query	3	653	May 2, 2019