Re: SQL Question (Comparing 2 files)

[steven.ryan@xxxxxxxxxxxx]

Mike

Any reason you need to use SQL?  This sort of comparison can easily be done
in Query by using an option 3 join (Unmatched records with primary file).

Steven



                    "Wills, Mike N.
                    (TC)"                      To:     
"'midrange-l@midrange.com'"
                    <MNWills@taylorcorp        <midrange-l@midrange.com>
                    .com>                      cc:
                    Sent by:                   Subject:     SQL Question 
(Comparing 2 files)
                    midrange-l-admin@mi
                    drange.com


                    18/12/01 08:56
                    Please respond to
                    midrange-l






I am comparing 2 files that should have similar records in each file. For
example file 1 has vennum and vendiv and file 2 has vennum and divnum. Both
files are directly related to each other and should have one unique
matching
record in each file. I am trying to figure out which records don't have a
match in the other file. How is this done?

Is this what I should use?
SELECT *
  FROM FILE1 A EXCEPTION JOIN FILE2 B
     ON A.VENNUM = B.VENNUM AND
        A.DIVNUM = B.DIVNUM

It doesn't seem to give me the correct result set.

TIA,
Mike
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.