(Greg Robidoux) Sometimes there is a need to combine data from multiple tables or views into one comprehensive dataset. This may be for tables with similar data within the same database or maybe there is a need to combine similar data across databases or even across servers.
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help