insert Query for sql server

Question

how to insert the id of another table in a table using query.. i need the query for getting the script..

for example 

i need the id of tableB in tableA.. 

 

i tryd this

insert in tableA (name,tableBid)('some name',select id from tableB where name='something')

 

this is not working