Query from multiple data sources
To this point I have not found a way to write a query using tables from different data sources. I would like to join two SQL tables that exist on different servers. I can do this in Access and would like to do it in SQL Reporting Services. Does anyone know if this can be done and if so how?