Select into tb.column from different tb.column

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?
Who is Participating?
Erick37Connect With a Mentor Commented:
Updates one table with info in another table joined on employee_no. ??

   somecolumn = b.someothercolumn
FROM TableOne a
INNER JOIN TableTwo b ON a.employee_no = b.employee_no
Carl TawnSystems and Integration DeveloperCommented:
You mean something like:

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

Guy Hengel [angelIII / a3]Billing EngineerCommented:
I think you want to UPDATE with JOIN ...
see this article:
JYLWestAuthor Commented:
managed to come right but very close to where i needed to be.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.