Eliminate duplicate rows

I need a little help with the following problem:

I would like to have a result set containing all entries of one table that are not distinct. Then delete them if they are found in another table e.g.:

SELECT DISTINCT value FROM table A

value
-------
101
250
300

DELETE FROM table B WHERE value != 101 AND value != 250 AND value != 300


Is there a way to do what I've done above quicker than these?


Any ideas?
Thanks!

not totally sure i understood your situation but it sounds like this:

delete from tableB
where value not in
( select distinct value from tableA )

rudy
http://r937.com/