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!

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

How can I print records from one DB that don't exist in another DB

Status
Not open for further replies.

5timesnc

Programmer
Feb 21, 2002
8
0
0
US
First, thanks for any assistance you can provide. I've only been using Crystal a couple of weeks. I have an Oracle DB that I need to compare to an AS/400 DB (through ODBC) which is already set up and I am able to link the two DBs. If you link different DBs, you have no control as far as the join is concerned, as it defaults to an equal join. I need to print records from the first DB, that don't have a corresponding record in the second DB. I will also need to do the same compare of DBs, in reverse order. I hope this makes sense to someone out there. If this requires any coding, an example would be GREAT. Thanks again.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top