如何使用另一个表中的现有数据和输入的值插入新行？

I'm trying to insert a row into a table, and in that row I want one column to contain data from a specific column in another table while also inserting static data into the same row. Something like this:I'm trying to insert a row into a table, and in