title: Creating one Table from three different Tables
body: <p>I have three tables in SQL and I need them to all be combined into one. I need all the fields from all the tables in the one table. All the tables contain the same fields just from three different years. I wrote a code that is:</p>
  
  <pre><code>CREATE TABLE COL_TBL_TRAINING_ALL_YEARS AS(
  SELECT 
  COL_TBL_2010_TRN_RESULTS_new.*,
  COL_TBL_TRN_RESULTS_GEMS_2011.*, 
  COL_TBL_TRN_RESULTS_GEMS_2012.*
  FROM COL_TBL_2010_TRN_RESULTS_new,
  COL_TBL_TRN_RESULTS_GEMS_2011, 
  COL_TBL_TRN_RESULTS_GEMS_2012
  WHERE COL_TBL_2010_TRN_RESULTS_new.SYS_EMP_ID_NR = COL_TBL_TRN_RESULTS_GEMS_2011.SYS_EMP_ID_NR = COL_TBL_TRN_RESULTS_GEMS_2012.SYS_EMP_ID_NR)
  </code></pre>
  
  <p>And I get an incorrect syntax near the word 'AS' error and incorrect syntax near '='</p>
  
  <p>I have read my SQL books and cannot seem to find an explanation on the method to do this, any help would be greatly appreciated.</p>