>
> >I think it's easier like this:
> >insert into table_ (field1, field2)
> >select val1_1, val2_1 from rdb$database union all
> >...
> >select val1_2, val2_2 from rdb$database;
>
> Agree, as far as you have the tables with the source data.
>

Those are constants. Something like this:

insert into ...
select 'foo', 42 from rdb$database ...

Sasha