Join between two databases

P

Pedro Faraco

New Member
I use Merant ODBC and I need to make SQL joins between tables located on two different Progress Databases.

In 4GL, we can access tables located on different working databases like they were on the same database.

How can we do this through SQL-92?

________________
Pedro Faraco
 
Hello,
You are using odbc connection with wich sort of tools?, i don't see difficulties to join and extract data from two different database, u just have to param two odbc connection and then connect the both database from u're tools and then make join.
 
I'm connecting via ODBC to two Progress databases from a single PHP script.

Since I have different handles for each connection and I can only send SQL commands through these conections separately, there is no way to send one single command that joins tabels of the two different databases, am I right?
 
You must log in or register to reply here.
Back
Top