Joins

[dcjames]

Hoping someone may have a solution for a problem that I'm having.

I have 2 text files that contain an ID and a Host Name in both files. I'm looking to have returned only those Host Names that appear in 1 file but not the other.

Here's an example

File A File B
ID Host ID Host
SS0962 ABIG SS0962 ABIG
SS0962 ASG SS0962 ASG
SS0962 LDAP

What I'm looking to have returned would be only SS0962 LDAP from File A ( since there is no match in File B).

I have tried outer joins, is nulls, not is null,etc with not much luck

Any help is appreciated

 

[FireGeek21]

dcjames,

Try looking at lbass' response in this post:

http://www.tek-tips.com/viewthread.cfm?qid=1659485

This worked great for me.

Good Luck.

FireGeek
(currently using Crystal Reports XI with Lawson 9.01)