CREATE VIEW V_TEST

AS

            SELECT *

                        FROM CH1.DB1.TEST1

            UNION ALL

            SELECT *

                        FROM CH2.DB2.TEST2

By using profiler, we can confirm that query establish connection on CH1 and CH2 simultaneously, but run it serially.