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	2115	November 19, 2016
How to use sub-query in n1ql SQL++	3	2262	December 16, 2015
Help about SubQuery SQL++	4	1555	May 28, 2017
Why USE KEYS error shown when using DB name SQL++ query , n1ql	7	711	June 2, 2023
USE KEYS references wrong data in correlated subquery SQL++ n1ql	5	839	November 3, 2021