Add data from one table to another
<p>I'm new at SQL I am stuck at this.
I have two tables
Table 1->4 Columns
Table 2->3 columns( 2 Same column names as in table 1)</p>

<p><strong>Table 1</strong></p>

<pre><code>UserID    Email    Name     Pass
--------------------------------
xyz      abc@123   xyz      xyz
123      123@xyz   abc      123
</code></pre>

<p><strong>Table 2</strong></p>

<pre><code>EmpID    Email    Name     
-----------------------
xyz      abc@123   xyz  
</code></pre>

<p><strong>Result-Table2</strong></p>

<pre><code>EmpID    Email    Name     
-----------------------
xyz      abc@123   xyz     
         123@xyz   abc
</code></pre>

<p>The table above are smaller ones, I have table with more than 60 columns. I want a method which can copy the common columns from table 1 to table 2.</p>