Re: Join between tables of two or more databases

[Reg Me Please <regmeplease(at)gmail(dot)com>]

Il Wednesday 31 October 2007 11:47:46 T.J. Adami ha scritto:
> Hi people. I have 2 databases named as follows:
>
> 1) company_a
>
> 2) company_b
>
>
> These two databases do not have the same ER model. However, I want to
> access tables on "company_a" there are in "company_b". I want to use
> them as local tables (as other databases like Sybase allows, since you
> have opened a database link).
>
> The question is: can I do this using remote database servers
> (different hosts)? If does not, can I do it at least on local
> databases on the same server?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

As far as they are "different databases", you cannot do it at the moment.
It doesn't matter whether they are local or not.
The only option should be to do it at the application level with two
connections.

-- 
Reg me Please