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.






As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.