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: "'email@example.com'" <MNWills@taylorcorp <firstname.lastname@example.org> .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-Lemail@example.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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.