sql query

[ptvce]

i have 2 table in sqlserver. i want do this command insert into dabirestan (amuzeshgah) values (select amuzeshgah from dabirestan1) i want fill the record of table dabirestan1 to table dabirestan i want write a query. how is my query cammand. do any body know?

[Blue_Boy]

try insert into dabirestan (amuzeshgah) select amuzeshgah from dabirestan1

---

I Love T-SQL "Don't torture yourself,let the life to do it for you."

[zahedonline]

What Blue_Boy suggested was 100% right in addition to it please make sure that the Second table you use should have the same Design or Table structure of what you are trying to copy to... otherwise the query would fail... :laugh: Cheers,

ZAK