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?

thanks