I need to write a few lines of SQL that will suppress one file from another. I work in foxpro 2.6 for DOS (i know its old but it works for us) we have name and address files. We want to suppress one .dbf from another .dbf. Here is what i have but it wont work. HELP!!
&&&& 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.fn <> small fn ;
ORDER BY LARGE.Z5 ;
INTO TABLE SUPP.DBF