N1QL JOIN condition

SQL++
1

How can I filter condition in ON clause?

SELECT usr.personal_details, orders
    FROM users_with_orders usr 
        USE KEYS "Tamekia_13483660" 
            LEFT NEST orders_with_users orders 
                ON (KEYS ARRAY s.order_id FOR s IN usr.shipped_order_history END AND  orders.deleted=false)
`
2 
SELECT usr.personal_details,  ARRAY o FOR o IN orders WHEN o.deleted = false END AS orders
FROM users_with_orders usr  USE KEYS "Tamekia_13483660" 
LEFT NEST orders_with_users orders ON KEYS  (ARRAY s.order_id FOR s IN usr.shipped_order_history END)

Check out 17 example : https://blog.couchbase.com/ansi-join-support-n1ql/