X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E7341D1BB7B for ; Thu, 8 Apr 2004 04:52:03 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 12632-06 for ; Thu, 8 Apr 2004 04:52:00 -0300 (ADT) Received: from hotmail.com (bay13-f19.bay13.hotmail.com [64.4.31.19]) by svr1.postgresql.org (Postfix) with ESMTP id 8BB05D1B441 for ; Thu, 8 Apr 2004 04:51:59 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 8 Apr 2004 00:52:00 -0700 Received: from 219.94.111.118 by by13fd.bay13.hotmail.msn.com with HTTP; Thu, 08 Apr 2004 07:52:00 GMT X-Originating-IP: [219.94.111.118] X-Originating-Email: [ynching@hotmail.com] X-Sender: ynching@hotmail.com From: "yek ching" To: pgsql-sql@postgresql.org Subject: pgsql multi-database queries Date: Thu, 08 Apr 2004 07:52:00 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 08 Apr 2004 07:52:00.0563 (UTC) FILETIME=[5FCC7830:01C41D3E] X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=2.4 tagged_above=0.0 required=5.0 tests=BAYES_44, DEAR_SOMETHING, RCVD_IN_RFCI X-Spam-Level: ** X-Archive-Number: 200404/83 X-Sequence-Number: 17458 Dear Sir/Miss, Is there a way to do a multi-database select query??.. I fail to find the related solution... currently i i created seperate table call stockmaster under seperate database for each seperate organizations... When i want to queries out the stock item qty for multi database, i face a problem where sql only can work for single database.. How can i use the same SQL statement in Pgsql??.. "SELECT * FROM A.stockmaster,B.stockmaster where A.item=B.item" Regards, Ching _________________________________________________________________ Are you in love? Find a date on MSN Personals http://match.msn.com.my/