RE: Matching Records

THarteau@xxxxxxxxxxxxxxxxxx wrote:

Hi,
I was wondering if there is a 'modern' way of doing matching
records. MR seems to be the way to write the program I am designing, but
it has been years since I did one. I am building two work files, and

need

to print any differences, or if there are any missing in either file.

Just

wondering if there was a better way.

From: Scott Klement

An exception join, perhaps?

Nope. An exception join returns rows in the primary without a match in the
secondary, but will skip records in the secondary without a match in the
primary. SQL always drives off the primary (leftmost) file.

Since Terri needs differences (rows exist in both files) and exceptions
(rows in either one file or the other), I think she'd most likely need an
OUTER JOIN with a UNION to an EXCEPTION JOIN with the file order reversed.

MR is actually the simpler solution, provided you remember how to code it
<grin>.

Joe