I want to see my reviews but it does not show it only the product fields/rows
https://query-tutorial.couchbase.com/tutorial/#14
I combine the product and reviews collections together:
SELECT
p.*, r.*
FROM product AS p
LEFT NEST reviews AS r
ON (META(r).id in p.reviewList) WHERE META(p).id = 'product320';
if I use SELECT * then it works but I have to calculate the avg so I have to use this:
SELECT
p.*, r.type, avg(r.rating) ....
NEST makes r as ARRAY
SELECT
p.*, ARRAY_AVG(r[*].rating) AS avg_ratings
FROM product AS p
LEFT NEST reviews AS r
ON (META(r).id in p.reviewList) WHERE META(p).id = 'product320';