How to insert table data based on other table id

Question

Hi, I want to insert values to one table based on other table id. if ID match then insert the data.

 

 

Please give me sample stored procedure  query.

 

Thanks