Re: Select between two databases

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                                              #
`************************************************************************/