Need help with writing a basic n1ql query in java

[srao...@gmail.com]

Hi,

I have just started learning couchbase. i am trying to write a basic query using java sdk but i am not able to understand how to write it.Below is the query.

 SELECT * 

        FROM users_with_orders usr 

                JOIN orders_with_users orders 

                    ON KEYS ARRAY s.order_id FOR s IN usr.shipped_order_history END

LetPath path=select("*,META(usr).id as _ID,META(usr).cas as _CAS).from(bucketName +" usr").join(bucketname +" orders").onKeys("usr.order_id) -----this is for joining without array

how should i proceed with the above query for on keys array.

Thanks!!!!

[Gerald]

Hi,

Can you post this on Couchbase N1QL forums or Stack Overflow, and we can help you there.