Tutorial by Examples

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

Page 1 of 1