Inserting value from one table into another in SQL Server

Question

I want to insert value of primary key of a table to the foreign key in another table in SQL Server.

Please help me out..

Answer 1

Insert Into FKTable (FKValue)
Select PKValue
From PKTable

Answer 2

AN EXAMPLE:

INSERT california_authors (au_id, au_lname, au_fname)
       SELECT au_id, au_lname, au_fname
         FROM authors
    WHERE State = 'CA'

Answer 3

SELECT PrimaryKey INTO NewTable FROM OldTable