insert into ANY_TABLE(ID,NAME) select ID,NAME from ANOTHER_TABLE

update or insert into ANY_TABLE(ID,NAME) select ID,NAME from ANOTHER_TABLE

execute block (DATE_TO timestamp = ?DATE_TO) 
as begin 
insert into TMP$ITEMS( ID, NAME) select ID,'Договора'|| ID from SPD$ORDERS where DATE_CREATE < :DATE_TO and ID > 0;
insert into TMP$FACTS( ID_ITEM, ID_DIMENSION, FACT_VALUE) select ID,1018, ID from SPD$ORDERS where DATE_CREATE < :DATE_TO and ID > 0; 
end