How to Select Data from 2 Database by 1 SQL

[AskProf]

I need to get data from tables in 2 databases. Is there a way to realize by 1 SQL? The database is oracle type and I use VB. I know how it does with Access database by absolute path. So I believe there should be also a way for Oracle.

Anyone helps?

[davide++]

Hi all.

I suppose that both databases are Oracle.

If the tables belong to distinct schemas (say schema A and schema B) on the same database instance you may grant one table of schema A on schema B; otherwise, if there are two db instance, you have to create a db link.
In both cases you can see the two tables as belonging to the same database.

I hope this will help you.

[AskProf]

Thanks and I'll try.