Marc, I would use an intermediate temp table to limit the rows. In block form,
1. You must have a PK on the table (Table1). 2. Project Temp Table2 FROM Table1 WHERE col2 = 'xyz' 3. DEL DUP FROM Table2 USING .... 4. DELETE FROM Table1 WHERE col2 = 'xyz' AND <pk> NOT IN + (SELECT <pk> FROM Table2) --- Marc <[EMAIL PROTECTED]> wrote: > Hi all > > I know you can do > Delete Duplicates from Table using col1,col2.... > But is there a way to add a where clause like > Delete Duplicates from Table using col1,col2....where col2 = 'xyz' > > I need something like this but can't figure out how to do it. > > Thanks > marc > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
