title: Is there a way to unnest an array in one select statement?
body: <p>I have the following:</p>
  <pre><code>CTE AS (
    SELECT 
      IssueID, CompanyName, Customer.ID FROM
   ( SELECT
      IssueID,
      REGEXP_EXTRACT_ALL(CompanyName,'[a-zA-Z]{3,4}[0-9]{3,4}') AS CompanyName
    FROM 
      `DWH.website` Website
    LEFT JOIN  `DWH.issues` AS Issue ON DWH.IssueID = Issue.ID) AS BASE
  
  CROSS JOIN UNNEST (CompanyName) AS CompanyName
  LEFT JOIN 
    DWH.Customer ON  CompanyName = Customer.CompanyName
  )
  </code></pre>
  <p>I would like to know if there is a more efficient way of writing this, specifically if there is a way to UNNEST in one Select Statement.</p>
  <p>Example of Desired Output</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>IssueID</th>
  <th>CompanyName</th>
  <th>ID</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>18677</td>
  <td>Google</td>
  <td>19435</td>
  </tr>
  <tr>
  <td>18677</td>
  <td>Logitech</td>
  <td>22345</td>
  </tr>
  <tr>
  <td>34564</td>
  <td>Target</td>
  <td>76845</td>
  </tr>
  </tbody>
  </table>
  </div>