Re: [SQL] SELECT with INNER data bases

2002-10-10 Thread Roberto Mello
On Thu, Oct 10, 2002 at 09:37:49AM -0300, 2000 Informática wrote: > 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 !

Re: [SQL] SELECT with INNER data bases

2002-10-10 Thread Bruno Wolff III
On Thu, Oct 10, 2002 at 09:37:49 -0300, 2000 Informática <[EMAIL PROTECTED]> wrote: > 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 ? Po

[SQL] SELECT with INNER data bases

2002-10-10 Thread 2000 Informática
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 !   Sil