SQL Suppression code FOXPR0 2.6 DOS

• gh449

  Valued Member

  Points: 54

  More actions

  February 18, 2013 at 7:04 am

  #270242

  Hello,

  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.

  Thanks,

  gbhiner

  &&&& 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

• Ant-Green

  SSC Guru

  Points: 113445

  More actions

  February 18, 2013 at 7:08 am

  #1588837

  Duplicate post, replies here please http://www.sqlservercentral.com/Forums/Topic1421182-2799-1.aspx