Washing Data - ie, deleting duplicate records in tables

[JSquare]

I have a master table that consists of a list of numbers
from the DNC list. I have a series of tables that are
created each month when new leads come in. I want to
automate a procedure (run a query) that looks at the
master table, look at the newly created table and compare
the telephone field to find a duplicate entry (ie, the
same phone number) in the new table. Whenever it sees a
duplicate in the new table, it deletes that record from
the table thereby creating a list that is ok to contact.
This is not working. When I run the query (written in SQL)
the results come by blank. Yet when I manually parse
through the two tables I see duplicates. Help!

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

First off, from a db normalization point of view, the monthly data
shouldn't be in separate tables, it should all be in one table. That
table would have a date column that indicates the month (or complete
date) of the record.

Second, it is very difficult to diagnose a problem when we can't see the
query that is causing the problem. Show us the query.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQSpe6YechKqOuFEgEQKSjQCdF4Ge994DjuSwSxY0yExZ0X/HbQkAoKfO
yHsrdnDYL2EjQOpSFs4/HoXG
=q15C
-----END PGP SIGNATURE-----