Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

-- Get the json extracts in the first query, then aggregate them in the second query. We cannot use cross joins, because records without ALL the seleted selected array elements will drop out. 

...