分层数据库选择/插入语句（SQL Server）

I have recently stumbled upon a problem with selecting relationship details from a 1 table and inserting into another table, i hope someone can help.I have recently stumbled upon a problem with se