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]