From: 2000 Informática <2000info@netsite.com.br>
To: pgsql Ludwig Lim <lud_nowhere_man@yahoo.com>
To: pgsql Laurette Cisneros <laurette@nextbus.com>
To: pgsql Christoph Haller <ch@rodos.fzk.de>
To: pgsql Achilleus Mantzios <achill@matrix.gatewaynet.com>
To: PG SQL Mailim <pgsql-sql@postgresql.org>
Subject: SELECT with INNER data bases
Date: Thu, 10 Oct 2002 09:37:49 -0300
Message-ID: <005101c27059$d970be00$0100a8c0@Info2000.com.br> (raw)
Hi,
I have two data bases: db1 and db2.
In MS SQL Server I can use
'SELECT T1.ID, T2.NAME FROM db1..table1 T1 INNER JOIN db2..table2 T2
ON T1.ID = T2.ID ...'.
How I do it in the PosgreSQL ?
HELP ME, PLEASE !
Sorry,
I'm a Brazilian and I don't speak and write English very well !
Silvio
2000Info
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: 2000info@netsite.com.br, lud_nowhere_man@yahoo.com, laurette@nextbus.com, ch@rodos.fzk.de, achill@matrix.gatewaynet.com
Subject: Re: SELECT with INNER data bases
In-Reply-To: <005101c27059$d970be00$0100a8c0@Info2000.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox