From: Janos Koppany
Date: July 22 1999 5:19am
Subject: How to UNION in MySQL ?
List-Archive: http://lists.mysql.com/mysql/8077
Message-Id: <3796A9D3.15F269E@intland.com>
MIME-Version: 1.0
Content-Type: multipart/mixed;
 boundary="------------9BAC446C7A9AB0CD59A0FD83"

--------------9BAC446C7A9AB0CD59A0FD83
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

with some databases I can select from multiply databases with UNION like

    SELECT      db1.foo .....
    UNION
    SELECT     db2.foo ....
    ....
    ORDER BY 1

Is there any way with MySQL to "merge" the db1.foo and db2.foo tables,
where the foo table structure is exactly identical in both databases.
In my application sometimes I just would see the db1.foo, or sometimes
the unions of db1.foo, db2.foo, .... , dbN.foo.

Thanks


Janos


--------------9BAC446C7A9AB0CD59A0FD83--