Message-ID: <39CE1B5D.B216E84F@earthlink.net>
Date: Sun, 24 Sep 2000 08:18:53 -0700
From: Fredrick Bartlett <palmtreefrb@earthlink.net>
MIME-Version: 1.0
To: Indraneel Majumdar <indraneel@www.cdfd.org.in>
CC: pgsql-sql@postgresql.org
Subject: Re: Select between two databases
References: <Pine.SGI.3.96.1000924171306.91135C-100000@www.cdfd.org.in>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Not sure if same can be accomplished with different servers.
Try the following for database's on one server,  use alias & dot notation...

select a1.colA1 from
myDatabase1.tableA1 a1
where a1.A2 in (select b1.colB1 from myDatabase2.tableB1 b1)

Indraneel Majumdar wrote:

> Hi,
>
> Does any one know how I may select between two databases running on same
> machine or on different machines eg.
>
> select colA1 from tableA1 where colA2 in (select colB1 from tableB1);
>
> here tableA1 and tableB1 are in different databases. The two databases
> might be under the same postmaster or on different machines under
> different postmasters. How do I query both simultaneously? Is it possible?
>
> Thanks,
> Indraneel
>
> /************************************************************************.
> # Indraneel Majumdar                  Ą  E-mail: indraneel@123india.com  #
> # Bioinformatics Unit (EMBNET node),  Ą  URL: http://scorpius.iwarp.com  #
> # Centre for DNA Fingerprinting and Diagnostics,                         #
> # Hyderabad, India - 500076                                              #
> `************************************************************************/