I have a bucket with multiple records differentiated by a single column called type. I need to join multiple such documents together . Can I run a join on the same collection? Select * FROM sample AS t1 JOIN sample AS t2 ON t1.id = t2.airportId WHERE t1.type='airport' AND t2.type='airplane';

Yes. e.g. SELECT * FROM `travel-sample` AS t1 JOIN `travel-sample` AS t2 ON t1.faa = t2.sourceairport WHERE t1.type = 'airport' AND t2.type = 'route'; works with the supplied sample. If you’re on 7.x and using collections, you could alternatively of course use, e.g. SELECT * FROM `travel-sam…

Can I run a Join query on the same bucket and on the same collection?

SQL++

vsr1 September 29, 2021, 1:35pm 4

Check out for examples

https://index-advisor.couchbase.com/indexadvisor/#1

Topic		Replies	Views
Is it possible put Joins on multiple document types in Same bucket SQL++ n1ql	6	3504	November 27, 2015
Join using joined bucket as key SQL++ query , n1ql , server	8	1690	June 6, 2018
Can use join clause in the same bucket? SQL++ 40-beta	4	3215	July 6, 2015
Join query not working in scopes SQL++ query , n1ql	3	537	April 20, 2022
Not sure if my N1ql query is correct SQL++	13	1605	May 10, 2017

Can I run a Join query on the same bucket and on the same collection?

Related topics