title: Append the specific column in another existing table using SQL QUERY
body: <p>I know it sounds easy when appending a entire row to new table, but this is different</p>
  
  <p><a href="https://i.stack.imgur.com/kMTMz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kMTMz.png" alt="This is Table 1"></a></p>
  
  <p><a href="https://i.stack.imgur.com/advvW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/advvW.png" alt="This is Table 2"></a></p>
  
  <p><a href="https://i.stack.imgur.com/oXtQs.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oXtQs.jpg" alt="This is Table 3"></a></p>
  
  <p>Question 1, state to combine the Table 1 and Table 2 and keep duplicate value, to create a new table, I have used the following query:</p>
  
  <pre><code>CREATE TABLE EMP_TBL_3
  (
      EMP_ID int,
      Name varchar(255),
      DOJ int
  );
  
  INSERT INTO EMP_TBL_3 (EMP_ID, Name, DOJ)
     SELECT * FROM EMP_TBL_1 
     UNION ALL
     SELECT * FROM EMP_TBL_2;
  </code></pre>
  
  <p>Results:</p>
  
  <p><a href="https://i.stack.imgur.com/yFwHn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/yFwHn.png" alt="Answer"></a></p>
  
  <p>Now the problem arise at 2nd question, saying: Take the D.O.B from EMP_BRTH_REC and combine them to EMP_TBL_3:</p>
  
  <p>I have tried this query:</p>
  
  <pre><code>ALTER TABLE EMP_TBL_3
  ADD DOB int;
  
  SELECT * FROM EMP_TBL_3;
  
  SELECT EMP_ID, Name, DOJ, DOB
  FROM EMP_TBL_3
  UNION ALL
  SELECT EMP_TBL_3.EMP_ID, EMP_TBL_3.Name, EMP_TBL_3.DOJ, EMP_BRTH_REC.DOB
  FROM EMP_BRTH_REC 
  LEFT JOIN EMP_TBL_3 ON EMP_BRTH_REC.EMP_ID = EMP_TBL_3.EMP_ID;
  </code></pre>
  
  <p>Results:</p>
  
  <p><a href="https://i.stack.imgur.com/hIAwQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/hIAwQ.png" alt="Error Result"></a></p>
  
  <p>My desired output is:</p>
  
  <p><a href="https://i.stack.imgur.com/Wue4r.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Wue4r.jpg" alt="enter image description here"></a></p>
  
  <p>How do I do that?</p>