Full Text Search JOIN clause

Full Text Search
1

What is the equivalent of JOIN in FTS query?

SELECT *
FROM `travel-sample` AS rte
JOIN `travel-sample` AS aln
  ON rte.airlineid = META(aln).id
NEST `travel-sample` AS lmk
  ON aln.landmarkid = META(lmk).id;
2

Hi @Gabriel_P1,

I haven’t refreshed myself on the N1QL query’s NEST option, but JOIN queries are something which FTS won’t be able to serve.

My understanding is that - Joins primarily combines results from different tables/buckets, and in FTS we don’t really have the concept of creating such temporary document sets internally from indexes built on different buckets to further process/parse the dataset with additional constructs.

Though FTS has the concept of index alias which performs a naive search result aggregation across different indexes.
ref: fts index alias

Cheers!