Hi,

>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
http://www.upscene.com

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

Database questions? Check the forum:
http://www.databasedevelopmentforum.com