CAN WE USE "EXECUTE" INSIDE OTHER STATEMENT LIKE NESTED query

N1QL
1

PREPARE prepareJoin
FROM SELECT *
FROM travel-sample r
JOIN travel-sample a ON r.airlineid = META(a).id
WHERE a.country = “France”
LIMIT 10;

EXECUTE prepareJoin;

2

You can prepare whole SQL statement (including subquery) and EXECUTE it. You can’t use execute inside another sql statement.

In side SELECT statement you can have subquery as another query block. The query block must be SELECT only and no other SQL statements

1 Like
3

THANKYOU…! VSRT
my doubts are clear now
tq very much