From guard@ficnet.net Tue Feb 13 10:31:03 2001 Received: from news.tht.net (news.hub.org [216.126.91.242]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1DAV3x58951 for ; Tue, 13 Feb 2001 05:31:03 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f1DATXK63066 for pgsql-sql@postgresql.org; Tue, 13 Feb 2001 05:29:33 -0500 (EST) (envelope-from news) From: "guard" X-Newsgroups: comp.databases.postgresql.sql Subject: how to select * from database1 table,database2 table Date: Mon, 12 Feb 2001 13:25:08 +0800 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 9 Message-ID: <96816m$ont$1@news.tht.net> X-Complaints-To: scrappy@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 To: pgsql-sql@postgresql.org X-Archive-Number: 200102/242 X-Sequence-Number: 1433 if join database1 database2 how to make I use VB or DELPHI thanks From guard@ficnet.net Tue Feb 13 02:01:20 2001 Received: from starbucks.iplus.net.tw (starbucks.iplus.net.tw [202.145.136.78]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1D21Jx96740 for ; Mon, 12 Feb 2001 21:01:20 -0500 (EST) (envelope-from guard@ficnet.net) Received: from win2000 (tc70-199.ci.seed.net.tw [210.244.70.199]) by starbucks.iplus.net.tw (8.9.3/8.9.3) with SMTP id KAA25757 for ; Tue, 13 Feb 2001 10:01:03 +0800 (CST) Message-ID: <005001c09560$70436d40$27c0c0c0@win2000> From: "guard" To: Subject: how to select * from database1 table,database2 table Date: Tue, 13 Feb 2001 09:58:04 +0800 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_004D_01C095A3.7547C6E0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200102/238 X-Sequence-Number: 1429 This is a multi-part message in MIME format. ------=_NextPart_000_004D_01C095A3.7547C6E0 Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: quoted-printable if join database1 database2 how to make I use VB or DELPHI thanks ------=_NextPart_000_004D_01C095A3.7547C6E0 Content-Type: text/html; charset="big5" Content-Transfer-Encoding: quoted-printable
if join database1 database2

how to make

I= use VB=20 or DELPHI

thanks
------=_NextPart_000_004D_01C095A3.7547C6E0-- From dev@archonet.com Tue Feb 13 12:04:52 2001 Received: from www-uk-05.digiserve.com ([195.172.23.63]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1DC4qx68154 for ; Tue, 13 Feb 2001 07:04:52 -0500 (EST) (envelope-from dev@archonet.com) Received: from mainbox.archonet.com (mwynhau.demon.co.uk [193.237.186.96]) by www-uk-05.digiserve.com (8.9.1/8.9.1) with ESMTP id MAA09645; Tue, 13 Feb 2001 12:05:26 GMT Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id 903D72A3AB; Tue, 13 Feb 2001 12:02:25 +0000 (GMT) Message-ID: <006801c095b4$d3b6d340$1001a8c0@archonet.com> From: "Richard Huxton" To: "guard" , References: <005001c09560$70436d40$27c0c0c0@win2000> Subject: Re: how to select * from database1 table,database2 table Date: Tue, 13 Feb 2001 12:02:21 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="big5" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200102/244 X-Sequence-Number: 1435 From: "guard" if join database1 database2 how to make I use VB or DELPHI You can't join between databases at present. I don't think this is in the pipeline for 7.2 even. The only solution I know of at present is to connect to two databases in the application and do the join "by hand" there. - Richard Huxton From josh@agliodbs.com Wed Feb 14 16:33:15 2001 Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1EGXFx55133 for ; Wed, 14 Feb 2001 11:33:15 -0500 (EST) (envelope-from josh@agliodbs.com) Received: from [207.172.28.154] (HELO agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.3) with ESMTP id 1190481 for pgsql-sql@postgresql.org; Wed, 14 Feb 2001 08:33:09 -0800 Message-ID: <3A8AB351.F10690E0@agliodbs.com> Date: Wed, 14 Feb 2001 08:33:21 -0800 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions X-Mailer: Mozilla 4.73 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: sqllist Subject: Re: how to select * from database1 table,database2 table References: <96816m$ont$1@news.tht.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200102/262 X-Sequence-Number: 1453 "guard": > if join database1 database2 > > how to make Folks, this really needs to be on a FAQ somewhere: PostgreSQL does not support inter-database Joins. Period. If you want to join tables from two different databases, I suggest that you use your front-end code to do so. I would also suggest that you review your data architecture and see if it's really necessary for you to store your data in two seperate databases. -Josh Berkus -- ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco