N1ql - Query An Inner Join For Two Different Queries

I'm new to N1QL, and i'm trying to query an Inner Join for two different queries but I get the exception below. (important to mention that each query was tested separately - and i

Solution 1:

Currently, the right hand term of a JOIN must be a table / bucket. You can rewrite your query to perform the right hand aggregation after the JOIN.