Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id DF5E147655A for ; Thu, 10 Oct 2002 08:28:43 -0400 (EDT) Received: from smtp.netsite.com.br (unknown [200.187.175.85]) by postgresql.org (Postfix) with ESMTP id 5BEBD476482 for ; Thu, 10 Oct 2002 08:28:42 -0400 (EDT) Received: from server2000 (netsite-fac-f1-022.idial.com.br [200.225.231.22]) by smtp.netsite.com.br (Postfix) with SMTP id 01F5B20414A; Thu, 10 Oct 2002 09:28:05 -0300 (BRT) Message-ID: <005101c27059$d970be00$0100a8c0@Info2000.com.br> From: =?iso-8859-1?Q?2000_Inform=E1tica?= <2000info@netsite.com.br> To: "pgsql Ludwig Lim" , "pgsql Laurette Cisneros" , "pgsql Christoph Haller" , "pgsql Achilleus Mantzios" , "PG SQL Mailim" Subject: SELECT with INNER data bases Date: Thu, 10 Oct 2002 09:37:49 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_004E_01C27040.B2C29670" 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-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/133 X-Sequence-Number: 9850 This is a multi-part message in MIME format. ------=_NextPart_000_004E_01C27040.B2C29670 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I have two data bases: db1 and db2. In MS SQL Server I can use=20 'SELECT T1.ID, T2.NAME FROM db1..table1 T1 INNER JOIN db2..table2 T2 ON T1.ID =3D T2.ID ...'. How I do it in the PosgreSQL ? HELP ME, PLEASE ! Sorry,=20 I'm a Brazilian and I don't speak and write English very well ! Silvio 2000Info ------=_NextPart_000_004E_01C27040.B2C29670 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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=20 JOIN db2..table2 T2

ON T1.ID =3D T2.ID ...'.

How I do it in the PosgreSQL ?

HELP ME, PLEASE !

Sorry,

I'm a Brazilian and I don't speak and writ= e English=20 very well !

Silvio

2000Info

------=_NextPart_000_004E_01C27040.B2C29670--