SELECT with INNER data bases

From: 2000 Informática <2000info(at)netsite(dot)com(dot)br>
To: "pgsql Ludwig Lim" <lud_nowhere_man(at)yahoo(dot)com>, "pgsql Laurette Cisneros" <laurette(at)nextbus(dot)com>, "pgsql Christoph Haller" <ch(at)rodos(dot)fzk(dot)de>, "pgsql Achilleus Mantzios" <achill(at)matrix(dot)gatewaynet(dot)com>, "PG SQL Mailim" <pgsql-sql(at)postgresql(dot)org>
Subject: SELECT with INNER data bases
Date: 2002-10-10 12:37:49
Message-ID: 005101c27059$d970be00$0100a8c0@Info2000.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruno Wolff III 2002-10-10 12:41:50 Re: SELECT with INNER data bases
Previous Message Achilleus Mantzios 2002-10-10 11:23:23 Re: SQL Error