Thanks Albert
I always learn a new way of doing something that I never thought of. But that would be a cool improvement to the Delete Dup command, at least for the strange things I want to do. Thanks marc > 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] > >
