How to UNION in MySQL ?

[Janos Koppany]

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