We need to write a few lines of sql that will compare one file (as dbf) to another. Then output the records that are the not the same. This would be the suppression file. Example. I have 10,000 records in a master file.
I selected all the records that of customers that lived in Atlanta and Austin say 150 records. I want to be able to suppress those names from the master and create an output file of not equal to the atlanta austin file.
This is my effort. not working. Any help would be greatly appreciated.
&&&& A prg to supress two files based on Z5, LN , AD - FEB 2013 GH
&&&& "FEBSUP.PRG" all standard files
SELECT * ;
FROM LARGE, small ;
WHERE LARGE.Z5 <> small.z5 and Large.ln <> small.ln and Large.cy <> small.cy and large.st <> small.st ;
ORDER BY LARGE.Z5 ;
INTO TABLE SUPP.DBF