SQL++ - Chaining JOINs

JOIN, NEST, and UNNEST can be chained and combined, in any order, as many times as desired.

In the example on the right, we perform an UNNEST to generate a complete order that contains the order Ids along with the user details. This is then JOINed with the orders from the users_with_orders bucket.

To run this example, click the button in the top right corner of the code editor.

Code Editor

Output