Hi,

I am not sure where you want to use the data but you can follow the below method.

First Need to create a view like Select * from server1.table Union Select * from Server2.table

then...