title: Flattening with missing or no results
body: <p>I am pretty new to Bigquery and I would like to unnest 2 tables in one query.</p>
  
  <p>I tried to query below code but it did not work. It gave me this message: "This query returned no results".</p>
  
  <pre><code>SELECT
      timestamp AS Date,
      A.key,
      B.name
  FROM `pms_table_request_log.partners_request_log_*`,
       UNNEST(jsonPayload.response.body.channels) AS A,
       UNNEST(jsonPayload.response.body.data.rows) AS B;
  </code></pre>
  
  <p>I expect key and name to be unnested. </p>