RE: Matching Records

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

> 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