Retrieving data from two databases in different locations
Posted on 2009-04-30
I have two databases:
(Yes, they are really old paradox dbf databases...)
Both of them hold the same column names but different data the column names needed are:
Acco, Invoice, Date, Total, Disc
I need to merge both sets of data into one select statement so I can display the results.
I can find how to join two tables within the same connection (database) but I cannot find how to join two different databases entirely. I need to use a unique statement to open each database . How do I merge them?