将数据插入另一个select语句的引号内的值

I am trying to insert data into multiple columns of a table with specific values. However one varchar column will have its data value coming from another table select statement placed inside a quotes.I am trying to insert data into multiple column