Matching data from 2 db's, same data/different field length

[danhauer]

Forcing databases to work together sure doesn't seem easy in
CR! Whew! Here is my scenario:

I have two Oracle databases. One contains volume used table, plant
table. The other is a vendor database with vendor information tables.

My task:

Show volume by site code and vendor name and address.

VOLUME_INFO
PLANT_INFO
(Key: siteID, CHAR 75)

VENDOR
VENDOR_SITES_LISTING
(Key: siteID, CHAR 150)

I need to join the information from the two databases/four tables by
siteID.

Tell me how easy it is...

Thanks,

danhauer

 

[synapsevampire]

You can add multiple databases to one report, though the linking is limited.

Consider creating a Stored Procedure, or cheating this by linking the Oracle tables to a MS Access dataabse and using a Query in MA Access as the data source.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com