Subject Re: [firebird-support] copy data between tables
Author Martijn Tonies

>i have 2 tables in the same db with the same structure.
> i need to copy same rows from one table to the other.
> it's better if i can do it directly with a query without using procedures
> (but if it's the unique way it's ok too).
> how i can do that?

insert into newtable select * from oldtable

Optionally provide columns.

With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum: