I want to create a new table which gets its data from 2 different databases.
The problem is: how can I gather informatione from 2 different dbs and save them in one table?
Insert Into newTable ( Field1, Field2, Field3)
(Select Field1 From
(Select Field2, Field3 From
That example probably won't work. Whats the correct way to do it?
Thanks for your help