SQL++ - Nest(2)

The NEST operator is conceptually the inverse of JOIN. Instead of producing a cross-product of matching left and right inputs, a single result is produced for each left hand input, with the matching right hand inputs collected into an array.

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

Code Editor

Output