Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 413114763CA for ; Mon, 9 Sep 2002 04:57:48 -0400 (EDT) Received: from addr-mx02.addr.com (addr-mx02.addr.com [209.249.147.146]) by postgresql.org (Postfix) with ESMTP id EE82C4763BE for ; Mon, 9 Sep 2002 04:57:46 -0400 (EDT) Received: from proxy1.addr.com (proxy1.addr.com [209.249.147.28]) by addr-mx02.addr.com (8.12.5/8.12.2) with ESMTP id g898vlSV060755 for ; Mon, 9 Sep 2002 01:57:47 -0700 (PDT) Received: from JD1 ([202.71.153.170]) by proxy1.addr.com (8.11.6/8.9.1) with SMTP id g898vks91718 for ; Mon, 9 Sep 2002 01:57:46 -0700 (PDT) (envelope-from jayps@addr.com)(envelope-to ) Message-ID: <005101c257df$0343be50$a800a8c0@blraddrcom> From: "Jay" To: Subject: Database joins Date: Mon, 9 Sep 2002 14:28:04 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_004E_01C2580D.1BC61260" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Scanned-By: MIMEDefang 2.15 (www dot roaringpenguin dot com slash mimedefang) X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/43 X-Sequence-Number: 9320 This is a multi-part message in MIME format. ------=_NextPart_000_004E_01C2580D.1BC61260 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I have created two databases, db1 and db2 in my POSTGRESQL database system. And both the databases contains few tables also. Could you please help me to write a query which should retrieve data from b= oth the databases (Database joins and table joins) Expecting and earliest reply Regards Jay ------=_NextPart_000_004E_01C2580D.1BC61260 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

I have created two databas= es,=20 db1 and db2 in my POSTGRESQL database system.

And both the databases con= tains few=20 tables also.

Could you please help me t= o write a=20 query which should retrieve data from both the databases

(Database joins and table= =20 joins)

Expecting and earliest=20 reply

Regards

Jay

= ------=_NextPart_000_004E_01C2580D.1BC61260--