Hi, Following query gives result but the subquery part is coming empty for every user.What should be done to get the result from following query. SELECT pin_id,old_pin_id,place_id,place_name,pin_story,pin_rate,cat_name,child_cat_name,pin_create_date, place_lat,place_long,pin_type,images,(SELECT t…

Subquery couchabse

vsr1 February 2, 2018, 1:00pm 7

At present In N1QL, Correlated sub queries requires USE KEYS, so you need to primary key relation.

Topic		Replies	Views
How to use sub-query in n1ql SQL++	3	2232	December 16, 2015
Subquery in USE KEYS block SQL++ n1ql	2	2083	November 19, 2016
N1QL subquery in select SQL++	16	7935	October 16, 2017
Use variable from parent query in correlated query SQL++	3	1174	October 9, 2018
Help about SubQuery SQL++	4	1526	May 28, 2017