The ability to create a report based on a heterogeneous cross-database join is available through the use of Adaptive Server’s Component Integration Services. Component Integration Services allow you to connect to multiple remote heterogeneous database servers and define multiple proxy tables that reference the tables residing on those servers.
For information on how to create proxy tables, see the Adaptive Server documentation.
