Hi,

I'm running DB2 V 7.1 and I wish to write a SELECT query that queries
tables in multiple tables in different databases on the same instance.
Is this possible and if so, what should the FROM clause look like?

Thanks for your help...

Andy S. wrote:[color=blue]
> Hi,
>
> I'm running DB2 V 7.1 and I wish to write a SELECT query that queries
> tables in multiple tables in different databases on the same instance.
> Is this possible and if so, what should the FROM clause look like?
>
> Thanks for your help...
>[/color]
Yes thsi is possible. First you have to do:
UPDATE DBM CFG USING FEDERATED YES
Then you need to familiarize yourself with the concept of "NICKNAME"s
You may want to start here for a read:
http://www-128.ibm.com/developerwork...06purnell.html
(there is tons of information on deleveloperWorks, but DB2 V7.1 is quite
dusty ...)

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab