title: MySQL JSON_TABLE Multiple Nested Paths
body: <p>I have the following query: </p>
  
  <pre><code>SELECT * FROM
      JSON_TABLE(
      '{"TrackingIds":[-1,-2],"Matrices":[22,23]}' 
      ,"$" COLUMNS(
          NESTED path "$.Matrices[*]" COLUMNS (Matrices INT path '$'),
          NESTED path "$.TrackingIds[*]" COLUMNS (TrackingId INT path '$')
      )) AS  j;
  </code></pre>
  
  <p>Which yields: </p>
  
  <pre><code>Matrices    TrackingId
  22             \N
  23             \N
  \N             -1
  \N             -2
  </code></pre>
  
  <p>How would I get it produce the below:</p>
  
  <pre><code>Matrices    TrackingId
  22             -1
  23             -2
  </code></pre>
  
  <p>Almost like it is a Key Value lookup.
  Thanks,
  -Tanner</p>