Re: inner join between database

From: frbn <frbn(at)efbs-seafrigo(dot)fr>
To: "Huang(at)tanpopo-tane(dot)com" <huang(at)tanpopo-tane(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: inner join between database
Date: 2002-07-11 12:32:04
Message-ID: 3D2D7AC4.2060109@efbs-seafrigo.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bruno Wolff III a écrit:

> "Huang(at)tanpopo-tane(dot)com" <huang(at)tanpopo-tane(dot)com> wrote:
>
>Can I use Inner join two tables between two databases?
>
>if possible, how to write this SQL? If not, any other way to accomplish it?
>thank you!

the shorter I found was to "select into" a temporary table
which means combining 2 queries and do the inner join on it

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Dalitz 2002-07-11 12:37:28 Re: inner join between database
Previous Message Vince Vielhaber 2002-07-11 12:27:19 Re: I am being interviewed by OReilly