How Can I use insert into/Select from one Database table to another Database table. for more explanation I have one Data base with "UserDB" name and "UserTble" table and another-one with "WordDB" and "WordsTble" Table name.
Asked
Active
Viewed 284 times
1 Answers
0
As they are separated databases, you can't do it using only SQL.
You must make a query from source table, read sequentially all results from the query and insert each record in the target table.
Sergi and Replace
- 829
- 5
- 14
-
Dear Sergey, after many researching around "ATTACH DATABASE" and also "Intert/into method", finally I did what you said. thx – Araz Mohammadnejad Apr 13 '17 at 21:49