>
> >insert into table_ (field1, field2)
> >select val1_1, val2_1 from rdb$database union all
> >...
> >select val1_2, val2_2 from rdb$database;
>
> This just work if i have a populated table. Not my case. I am trying to
> insert new values.
>

I guess I wasn't very clear, sorry for that. You need to supstitute val?_? with your own values, like this:

insert into whatever(col1, col2, col3, col4)
select 'USD', 'EUR', 2008, 0.93 from rdb$database union all
select 'BLR', 'AUD', 2007, 0.93 from rdb$database;

Sasha