Although tables in SQL databases typically contain massive amounts of data, they’re not always in a format that can be used by data analysts. The data records in these tables need to be filtered ...

I *believe* the question is how to query remote servers not how to join the 5 tables into one query. But, yeah, a UNION combined with linked servers should accomplish what he wants. how it performs, ...