how to query multiple database

If you have the DB2 information center installed search for "DB2 Federated
Systems" in the SQL reference section. I did a quick glance and unfortunately
it doesn't look simple.

Mark

"M. Ruiz" <mruiz@uninet.edu> wrote:
>
>
>I need to access to multiple databases (in the same instance), but I don't
>know dow do it.
>
>select a.*, b.* from db1.table1 a, db2.table2 b where ....
>
>db1 & db2 are in the same server and in the same instance.
>
>Regards.
>M. Ruiz