Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.
danhauer

danhauer

Programmer
Apr 17, 2001
39
US
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
 
Status
Not open for further replies.

Similar threads

G
  • Locked
  • Question
Multiple groups in same level
Replies
0
Views
150
george1610
G
JustMe24
  • Locked
  • Question
How to select from 2 rows in a table
Replies
1
Views
472
SoftwareRT
SoftwareRT
bbranco
  • Locked
  • Question
Query Help - Group By 2 tables
Replies
0
Views
386
bbranco
bbranco
smmt2207
  • Locked
  • Question
Text field formula help
Replies
1
Views
493
hilfy
hilfy
anandm19
  • Locked
  • Question
Crystal report byte array data to Unicode data format export issue
Replies
0
Views
398
anandm19
anandm19

Part and Inventory Search

Sponsor

Back
Top