<div>
You mean something like:<br />
<br />
&nbsp; &nbsp;INSERT INTO [Table2] ([employee_no])<br />
&nbsp; &nbsp; &nbsp; &nbsp;SELECT [employee_no] FROM [Table1]<br />
<br />
?
</div>


You mean something like:

   INSERT INTO [Table2] ([employee_no])
       SELECT [employee_no] FROM [Table1]

?

<div>
I think you want to UPDATE with JOIN ...<br />
see this article: <a href="https://www.experts-exchange.com/A_1517.html" rel="ugc">https://www.experts-exchange.com/A_1517.html</a>
</div>


I think you want to UPDATE with JOIN ...
see this article: https://www.experts-exchange.com/A_1517.html [https://www.experts-exchange.com/A_1517.html]

<div>
managed to come right but very close to where i needed to be.
</div>


managed to come right but very close to where i needed to be.

<div>
<div class="content wysiwyg-content">
I have two tables, both contain employee_no and other column's, I need to 'copy' only the employee_no column into an existing tb, so that it can be updated with new information, how would I go about doing this?
</div>
</div>


I have two tables, both contain employee_no and other column's, I need to 'copy' only the employee_no column into an existing tb, so that it can be updated with new information, how would I go about doing this?

Select into tb.column from different tb.column

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.