Hi,
If I understand your code correctly, you can do it by
DELETE FROM new ;
WHERE ssn+holder_num+DTOS(date_rem) ;
IN (SELECT ssn+holder_num+DTOS(date_rem) as F1 from ssn)
HTH
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...