At 08:06 PM 4/03/2010, you wrote:

>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 table2 (field1, field2, field3, ...)
select field1, field2, field3, ... from tablea
where fieldx = .....

./heLen