Report How to JOIN tables from 2 databases in Visual FoxPro 7?

shadow14 · #1 (**permalink**) 03-13-09, 12:08

Hello Friendly Friends, I badly need your help..

This is my problem, I have 2 databases(DB1, DB2) in a system.

How will I be able to link or join the tables from this 2 different database?

I need to import the data of the table(T2) in DB2 to the table(T2) of DB1..

Thanks..

P.S. I'm using Visual FoxPro Version 7.0

gvee · #2 (**permalink**) 03-16-09, 05:25

SELECT - SQL Command

Code:

FROM [FORCE][DatabaseName!]Table [[AS] Local_Alias]

Quote:

DatabaseName!

Specifies the name of a non-current database containing the table. You must include the name of database containing the table if the database is not the current database. Include the exclamation point (!) delimiter after the database name and before the table name.

Internet Services

Web Development

Digital Marketing

Consumer Tech