I have a simple question that keeps me up all night 
.Suppose we have 2 databases on different servers.You can easily create 2 connections and manipulate data in both databases.What if I want to execute one query on both databases?Example : \[code\]INSERT INTO database1.table1 VALUES ( 'one','two','three') WHERE database1.table1.something LIKE (SELECT something from database2.table2)\[/code\]Sorry for my code, I'm not really experienced with sql code.Such attempts are possible when the databases are all accessible through the same connection.But is it possible to achieve the same result if the databases are on separate servers (when you need two connections) ?It would be so much easier for me if such a solution would exist .best regards
.Suppose we have 2 databases on different servers.You can easily create 2 connections and manipulate data in both databases.What if I want to execute one query on both databases?Example : \[code\]INSERT INTO database1.table1 VALUES ( 'one','two','three') WHERE database1.table1.something LIKE (SELECT something from database2.table2)\[/code\]Sorry for my code, I'm not really experienced with sql code.Such attempts are possible when the databases are all accessible through the same connection.But is it possible to achieve the same result if the databases are on separate servers (when you need two connections) ?It would be so much easier for me if such a solution would exist .best regards