Re: querying against multiple SE DBs

> The suggestion we received from tech support was to run the query > on the first db and save the output to an ascii file and do the > same on the second db - and then load both ascii files into a third > dummy database and then do sorting and calculations there. Must have been hung over... > We are looking for something that's a little more efficient than that. Can't blame you. > Is there anything like this for SE? Yes. What we generally did was to set up synonyms for the remote tables and then treat the whole thing as a local query. You must make sure that your engines can communicate (setup sqlexecd, etc.) HTH. -- Ciao, Billy +------------------------------------------------------------------------------+ | I used to be indecisive, but now I'm not so sure... | +------------------------------------------------------------------------------+