I'm trying to write a report (using Crystal 8.5) that joins tables in two different DBs to make the results look like a fluid document. One database is an archive of the other (exact same tables) but with data that is over 3 months old. The tables I'm using are set up like this:

Table A (archive DB):
InventoryId
CreationDTM
LotId
...

Table B (archive DB):
InventoryId
MoveDTM
MoveLocation
...

Table B (production DB):
InventoryId
MoveDTM
MoveLocation
...

I need to select by the Lot Id in Table A in the archive DB then have that select all transactions for the associated inventory (using the selected InventoryId field) from both the archive and production DBs. Can anyone help me out? We're using Oracle 8i. I could tell you all the things I've tried, but I think it would be easier to just start over. Thank you!