title: SQL Union ALL "Syntax Eror in From Clause"
body: <p>I'm struggling with MS Access 2010 SQL.  Can anyone see why the following SQL statement would produce a "Syntax Error in FROM clause?"</p>
  
  <pre><code>INSERT INTO Attendance 
  SELECT [AttendanceData].Student, [AttendanceData].[10/1/2015] AS AttendValue,
  "10/1/15" AS AttendDate
  FROM [AttendanceData]
  UNION ALL 
  SELECT [AttendanceData].Student, [AttendanceData].[10/2/2015] AS AttendValue, 
  "10/2/15" As AttendDate
  FROM [AttendanceData];
  </code></pre>
  
  <p>Individual statements work fine, but when combined with UNION ALL, I receive the </p>
  
  <blockquote>
    <p>Syntax Error in FROM Clause."  </p>
  </blockquote>
  
  <p>Any help would be much appreciated!</p>
  
  <p>Thank you.</p>