I want to run, basically, this, to show brewery info for any that make a Belgian-style Pale Ale: SELECT name, city, state, country FROM `beer-sample` brewery WHERE type = 'brewery' AND brewery.brewery_id IN ( SELECT beer.brewery_id FROM `beer-sample` beer WHERE style = "…

How to USE KEYS in N1QL subquery

geraldss December 16, 2015, 5:29pm 7

One document must contain the primary key (external key) of the second document…

1 Like

N1QL - select from subquery

Topic		Replies	Views
How to use sub-query in n1ql SQL++	3	2198	December 16, 2015
Subquery in USE KEYS block SQL++ n1ql	2	2061	November 19, 2016
Help about SubQuery SQL++	4	1498	May 28, 2017
USE KEYS references wrong data in correlated subquery SQL++ n1ql	5	796	November 3, 2021
Why USE KEYS error shown when using DB name SQL++ query , n1ql	7	640	June 2, 2023