From:                   "nafiseh saberi" <[EMAIL PROTECTED]>
> how can I copy one table to another table ???
> do we have one command for it in sql ??
> 
> thx a lot.
> ________________________________
> Sincerely yours     Nafiseh Saberi  

And why are you asking here?

Anyway you could have told us at least WHAT DATABASE are 
you using.

Basicaly if both the tables are in the same database an SQL like 
this should do:

        insert into Table2 ( Column1, Column2, Column3)
        select Column1, Column2, Column3 from Table1

But of course this may depend on the database.

Jenda

P.S.: Would you please read this? 
http://www.tuxedo.org/~esr/faqs/smart-questions.html

== [EMAIL PROTECTED] == http://Jenda.Krynicky.cz ==
: What do people think?
What, do people think?  :-)
             -- Larry Wall in <[EMAIL PROTECTED]>

-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to