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	2195	December 16, 2015
Subquery in USE KEYS block SQL++ n1ql	2	2055	November 19, 2016
Help about SubQuery SQL++	4	1492	May 28, 2017
USE KEYS references wrong data in correlated subquery SQL++ n1ql	5	783	November 3, 2021
N1QL subquery in select SQL++	16	7830	October 16, 2017