Insert into one table by selecting from another table

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