title: Trying to convert Access Insert query into MySQL query
body: <p>I'm trying to convert an Access INSERT query into a MySQL Pass Through Query but am not very familiar with MySQL.  I know my syntax is off, but I don't know exactly what the problem is.</p>
  
  <p><strong>ACCESS VERSION:</strong></p>
  
  <pre><code>INSERT INTO [tblHistoryThruToday RETAIN-STU-ADVISOR] ( [STUDENT ID], [ADVISOR ID], [COURSE TERM], [BLANK ADV TERM], [BLANK ADV TYPE], [BLANK DEPARTMENT], [BLANK PRIMARY ID], SOURCEFILE, [TIMESTAMP] )
  
  SELECT [tblHistory - RETAIN-STU-ADVISOR].[STUDENT ID], [tblHistory - RETAIN-STU-ADVISOR].[ADVISOR ID], [tblHistory - RETAIN-STU-ADVISOR].[COURSE TERM], [tblHistory - RETAIN-STU-ADVISOR].[BLANK ADV TERM], [tblHistory - RETAIN-STU-ADVISOR].[BLANK ADV TYPE], [tblHistory - RETAIN-STU-ADVISOR].[BLANK DEPARTMENT], [tblHistory - RETAIN-STU-ADVISOR].[BLANK PRIMARY ID], [tblHistory - RETAIN-STU-ADVISOR].SOURCEFILE, [tblHistory - RETAIN-STU-ADVISOR].TIMESTAMP
  
  FROM [tblHistory - RETAIN-STU-ADVISOR];
  </code></pre>
  
  <p><strong>My attempt at MySQL</strong> (I do have the ` marker on both sides of my table names, but you might not be able to see them in preview)</p>
  
  <pre><code>INSERT INTO `tblHistoryThruToday RETAIN-STU-ADVISOR` (‘STUDENT ID’, ‘ADVISOR ID’,’COURSE TERM’, ‘BLANK ADV TERM’,’BLANK ADV TYPE’, ‘BLANK DEPARTMENT’, ‘BLANK PRIMARY ID’, ‘SOURCEFILE’, ‘TIMESTAMP’ )
  
  SELECT `tblHistory - RETAIN-STU-ADVISOR`.‘STUDENT ID’, `tblHistory - RETAIN-STU-ADVISOR`.‘ADVISOR ID’, `tblHistory - RETAIN-STU-ADVISOR`.‘COURSE TERM’, `tblHistory - RETAIN-STU-ADVISOR`.‘BLANK ADV TERM’, `tblHistory - RETAIN-STU-ADVISOR`.‘BLANK ADV TYPE’, `tblHistory - RETAIN-STU-ADVISOR`.‘BLANK DEPARTMENT’, `tblHistory - RETAIN-STU-ADVISOR`.’BLANK PRIMARY ID’, `tblHistory - RETAIN-STU-ADVISOR`.‘SOURCEFILE’, `tblHistory - RETAIN-STU-ADVISOR`.‘TIMESTAMP’
  
  FROM `tblHistory - RETAIN-STU-ADVISOR`;
  </code></pre>