title: BigQuery - Using INSERT INTO to copy data from one nested table into another nested table
body: <p>Helping a customer out. I'm trying to copy one nested BigQuery table into another nested table and am running into the following error: "Syntax error: Expected ")" or "," but got ".""</p>
  
  <p>Query: </p>
  
  <pre><code>  INSERT INTO `&lt;GCP_PROJECT_NAME&gt;.Test_Tables.Nested_Person_Table2` (id,
      first_name,
      last_name,
      dob,
      address.status,
      address.address,
      address.city,
      address.state,
      address.zip,
      address.numberOfYears)
  SELECT
    id,
    first_name,
    last_name,
    dob,
    address.status,
    address.address,
    address.city,
    address.state,
    address.zip,
    address.numberOfYears
  FROM
    `&lt;GCP_PROJECT_NAME&gt;.Test_Tables.Nested_Person_Table`
  
  </code></pre>