How do i create a sql statement that allows me to select data from a table that exist on another connection.
Example i have 3 instances of the same database which contain data at 3 different times.
I have DEVL, PREPROD and PRODUCTION
I am trying to write an SQL statement that pulls data out of a table on the PROD connection and inserts the data into same table on the DEVL connection.
Can this be handled within an sql statement?