Bill, You can't put a where clause on to the end of the delete duplicates syntax. But you can project a new table and delete based on that.
PROJECT TEMP newtable from oldtable using * where compdate is null Delete duplicates from newtable using reqdate, section, range, plot Drop oldtable Project oldtable from newtable using * Drop newtable Dawn -----Original Message----- From: William Owens [mailto:[EMAIL PROTECTED] Sent: Friday, April 01, 2005 10:33 AM To: RBG7-L Mailing List Subject: [RBG7-L] - delete rows I have a table that can have duplicate rows (Dos 6.1) Is there a way I can delete dup rows based on certain fields? example 5 fields > reqdate, section, range, plot, compdate I want to delete the row where reqdate,section,range,plot are equal and compdate fails? Thanks Bill
