从另一个表中选择插入一个表

insert into schema.table (field1, field2)
  select 'Static Value', foreignField from schema.otherTable;