all from one table to another

I know one way (but it is complicated (using fetch))
copiing all data from one table to another table with
the same fields, but with different table name.
Could you tell me the easiest way to do that ?If I understand your question correctly, the easiest way would be:
Insert Table1(F1...Fn)
Select F1...Fn
From Table2
Thomas
"Alur" <Alur@.discussions.microsoft.com> wrote in message
news:703218BE-303C-4462-AA92-2DCDB1D751EE@.microsoft.com...
> I know one way (but it is complicated (using fetch))
> copiing all data from one table to another table with
> the same fields, but with different table name.
> Could you tell me the easiest way to do that ?|||Thank you
"Thomas Coleman" wrote:

> If I understand your question correctly, the easiest way would be:
> Insert Table1(F1...Fn)
> Select F1...Fn
> From Table2
>
> Thomas
>
> "Alur" <Alur@.discussions.microsoft.com> wrote in message
> news:703218BE-303C-4462-AA92-2DCDB1D751EE@.microsoft.com...
>
>