Not sure if my N1ql query is correct

SQL++
12

you can only JION on primary key ,FYI
https://developer.couchbase.com/documentation/server/4.5/n1ql/n1ql-language-reference/from.html#story-h2-3