Skip to Content
0
Former Member
Apr 17, 2014 at 04:25 PM

Concatenate tables with same name from different servers - CR2013

22 Views

Hello,

I need some help. I need data from 2 tables with the same name on different SQL servers thru an ODBC connection. When I try to get the data by adding both to my datasource I get data from one or the other. I have considered creating a view, but not sure how to handle this. Thanks.