Conditional query from multiple buckets

SQL++
1

Hello everybody. Can anybody say what am I doeing wrong in query:

SELECT
z.summ,
z.Settings,
s.Prices
FROM ZB AS z, Settings AS s
Where s.Meta().id = z.Settings AND z.Meta().id = “2345679812”

I have two buckets with names “ZB” and “Settings”. I need to extract fields: “summ” and “Settings” from document with id = “2345679812” in bucket “ZB” and the field “Prices” form document with id = settings in document selected in “ZB” bucket.

2

You did not tell what is issue. Follow https://blog.couchbase.com/ansi-join-support-n1ql/

SELECT
z.summ,
z.Settings,
s.Prices
FROM ZB AS z USE KEYS "2345679812" 
JOIN Settings AS s ON KEYS z.Settings ;