Re: Select between two databases

Поиск
Список
Период
Сортировка
От Indraneel Majumdar
Тема Re: Select between two databases
Дата
Msg-id Pine.SGI.3.96.1000924235807.98340A-100000@www.cdfd.org.in
обсуждение исходный текст
Ответ на Re: Select between two databases  (Fredrick Bartlett <palmtreefrb@earthlink.net>)
Ответы  (Keith Wong <keith@e-magine.com.au>)
Список pgsql-sql
Not working, but thanks anyway. Can anyone point out the relevant area of
the source where queries are handled?

Thanks,
Indraneel 

On Sun, 24 Sep 2000, Fredrick Bartlett wrote:

> Not sure if same can be accomplished with different servers.
> Try the following for database's on one server,  use alias & dot notation...
> 
> select a1.colA1 from
> myDatabase1.tableA1 a1
> where a1.A2 in (select b1.colB1 from myDatabase2.tableB1 b1)
> 

/************************************************************************.
# Indraneel Majumdar                  ¡  E-mail: indraneel@123india.com  #
# Bioinformatics Unit (EMBNET node),  ¡  URL: http://scorpius.iwarp.com  #
# Centre for DNA Fingerprinting and Diagnostics,                         #
# Hyderabad, India - 500076                                              #
`************************************************************************/



В списке pgsql-sql по дате отправления:

Предыдущее
От: Fredrick Bartlett
Дата:
Сообщение: Re: Select between two databases
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Select between two databases