X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 49C6BD1C4EB
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 30 Jul 2003 11:27:57 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 53304-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 30 Jul 2003 08:26:58 -0300 (ADT)
Received: from mailserver.tainam.com (ip-179-126-134-202.rev.dyxnet.com
	[202.134.126.179])
	by svr1.postgresql.org (Postfix) with ESMTP id 2D492D1C4E7
	for <pgsql-sql@postgresql.org>; Wed, 30 Jul 2003 08:27:54 -0300 (ADT)
Received: by mailserver.tainam.com with Internet Mail Service (5.5.2653.19)
	id <K2V5L6M8>; Wed, 30 Jul 2003 19:28:04 +0800
Message-ID: <E1710B82E845F2439B63043F1699E82877C29F@mailserver.tainam.com>
From: "Keith H.K. Lam (U1 Tech.)" <keithhk_lam@u1technology.com>
To: "'pgsql-sql@postgresql.org'" <pgsql-sql@postgresql.org>
Subject: select query that would join two databases
Date: Wed, 30 Jul 2003 19:28:04 +0800
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain;
	charset="big5"
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200307/496
X-Sequence-Number: 14610

dear all,

How to create a query that would join two databases? In MSSQL, i use

select * from dbA.dbo.tableA a dbB.dbo.tableB b where a.id=b.id

Is there anyway to write the above query in postgressql ?

Please email me back.
Thanks,
Keith