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
Subquery in USE KEYS block SQL++ n1ql	2	2093	November 19, 2016
How to use sub-query in n1ql SQL++	3	2240	December 16, 2015
Help about SubQuery SQL++	4	1536	May 28, 2017
N1QL subquery in select SQL++	16	7950	October 16, 2017
Error evaluating filter. - cause: FROM in correlated subquery must have USE KEYS SQL++ query , n1ql	2	3769	October 21, 2017