Help - Delete duplicate records comparing 2 tables

K

Karen M

I am in need of assistance. I have a table set up to receive a data feed on a daily basis. This table is called TBL_WORKING_WASP_FILE. I use this data to select a random sample of 100 and send surveys out. I then append the sample population to a table named TBL_MASTER_SAMPLE_FILE. I am running into problems because there may be duplicates between the TBL_WORKING_WASP_FILE and TLB_MASTER_SAMPLE_FILE. I do not want to send a survey out to someone who has already received one. Is there a way to cross check the data with the TBL_MASTER_SAMPLE_FILE to dedup. There is a unique customer id assigned to each person. Currently, my work around is to run a find duplicates query at the end, but because of some autoid issues with the sample data, this is proving to be cumbersome. Any suggestions would be helpful. Thanks!
 
N

Nikos Yannacopoulos

Karen,

Instead of selecting your sample directly from table TBL_WORKING_WASP_FILE,
employ a simple select query on the table, and put the following in the
criteria line below field customer id (or whatever you call it):

Not In (SELECT Customer_ID FROM TBL_MASTER_SAMPLE_FILE)

where I have assumed the customer id field in table TBL_MASTER_SAMPLE_FILE
is called Customer_ID; change as required.

HTH,
Nikos

Karen M said:
I am in need of assistance. I have a table set up to receive a data feed
Click to expand...
on a daily basis. This table is called TBL_WORKING_WASP_FILE. I use this
data to select a random sample of 100 and send surveys out. I then append
the sample population to a table named TBL_MASTER_SAMPLE_FILE. I am running
into problems because there may be duplicates between the
TBL_WORKING_WASP_FILE and TLB_MASTER_SAMPLE_FILE. I do not want to send a
survey out to someone who has already received one. Is there a way to cross
check the data with the TBL_MASTER_SAMPLE_FILE to dedup. There is a unique
customer id assigned to each person. Currently, my work around is to run a
find duplicates query at the end, but because of some autoid issues with the
sample data, this is proving to be cumbersome. Any suggestions would be
helpful. Thanks!
 
Top