insert value from one table to another checking id
===

I have 2 tables.All the ids are include in table one(Tbl_Distributor).2nd table have all the names.
I want to add all the names to first table according to id.

My select querry as below.



     INSERT INTO dbo.Tbl_Distributor(Giv_Name) where dealercode= a.dealercode
 
     SELECT a.dealercode,d.nameinfull  
     FROM dealerplacement a,dealer d
     where a.dealercode= d.dealercode
     order by a.dealercode ASC

   this return **nameinfull** and **dealercode**. I want to add this nameinfull  to **Tbl_Distributor** .

please help me to solve this issue.