Subject Re: [firebird-support] Select's output copied to a table
Author Helen Borrie
At 06:51 PM 11/09/2003 -0700, you wrote:
>Dear Forum members,
>I need your help in identifying a way to perform a Select
>statement and the result is automatically copied to some
>table. I used to do this operation with MS Access DBMS but
>I don't know whether Firebird support is or not.

The table must exist already.

insert into destination-table (col1, col2,,,,,,,,,)
select <matching-field-list> from source-structure