Re: how to query between 2 remote databases

>>>>> "kiran" == kiran <kiran.news.invalid_at_web2news.net> writes:

 kiran> How to query on two tables that are on two different remote  kiran> database with a join.

 kiran> s * f tb1_at_uid/pass_at_db1.world a, tb2_at_uid/pass_at_db2.world b w  kiran> a.col1 = b.col2

 kiran> but this does not work, any idea ?

 kiran> Thanks

Read up about database links. You need to create a db link and then use the syntax
select ....
from table_at_dblink_name
....

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!