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