Received: from web1.lighthouseasp.com (gw.lighthouseasp.com [216.191.176.98] (may be forged)) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4FJjtA70698 for ; Tue, 15 May 2001 15:45:55 -0400 (EDT) (envelope-from cbell@lighthouseasp.com) Received: from lighthouseasp.com (asp.lighthouseasp.com [66.46.48.3]) by web1.lighthouseasp.com (8.9.3/8.8.7) with ESMTP id PAA03366 for ; Tue, 15 May 2001 15:44:29 -0400 Message-ID: <3B0186D7.DD59D461@lighthouseasp.com> Date: Tue, 15 May 2001 15:43:19 -0400 From: cbell Organization: Lighthouse ASP X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Select between two connections Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200105/152 X-Sequence-Number: 2969 Hello everyone, I would like to perform a Select statement that accesses tables and finds matching fields in two separate databases. For example, I have two connections to two separate database objects on the same Postgres server. I would like to retrieve information from a table in one database based on some information from tables in a different database. Has anyone done this before, can it be done? Thanks in advance, Chris.