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.