Hello, I am learning n1ql and I am asking myself why one querie works and the other not. This works: SELECT p, c FROM purchases p INNER JOIN customer c ON (p.customerId = META(c).id) LIMIT 1 This not works: SELECT c, p FROM customer c INNER JOIN purchases p ON (p.customerId = META(c)…

[image] servermanager017: SELECT c, p FROM customer c INNER JOIN purchases p ON (p.customerId = META(c).id) You can run the index advisor like this: Advise SELECT c, p FROM customer c INNER JOIN purchases p ON (p.customerId = META(c).id) Which will give the advice as shown below. But it…

Whats the difference bewteen these two queries and why one works and the ohter not?

SQL++

system Closed February 11, 2024, 11:27pm 7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
No index available for ANSI join SQL++ query , n1ql	1	1435	December 2, 2019
N1ql query is slow in join even indexes are created SQL++ query , n1ql	3	594	August 14, 2022
No index available for ANSI join term error SQL++	2	1386	January 20, 2020
How can I nest purchases from Products without JOIN? SQL++	3	243	February 21, 2024
Data loading in N1ql SQL++ query , n1ql	16	1158	April 2, 2020

Whats the difference bewteen these two queries and why one works and the ohter not?

Related topics