List:General Discussion« Previous MessageNext Message »
From:Janos Koppany Date:July 22 1999 5:19am
Subject:How to UNION in MySQL ?
View as plain text  
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


Thread
How to UNION in MySQL ?Janos Koppany22 Jul
  • How to UNION in MySQL ?sinisa22 Jul
  • Re: How to UNION in MySQL ?Christian Mack26 Jul