Inner Join on fields


#1

Dear community,

Is there a way to make a inner join without using the document primary key ?

Doc1, primary Index : 1000
{
field1 : value1
field2: value2
}

Doc2, primary Index : 2000
{
fielda: value1
fieldb: valuec
}

I would make an inner join with field 1 and fielda.

Is it possible ?


#2

You can use ANSI JOINs to JOIN on the fields in Couchbase 5.50
https://blog.couchbase.com/ansi-join-support-n1ql/

Pre CB 5.50 you can only join with primary key only.