Duplicate Records

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have two tables which store an 11 digit zip code: table A and table B. I am
joining each of these tables using a join on the 11 digit zip code. Here is
my SQL statement:

SELECT *
FROM TableA, TableB
WHERE TableA.destzip=TableB.tm_extzip;

After execution I noticed the query creates duplicate records. For example,
when I create a query for a specific zip code, the result is one record with
a specific date and time stamp. When I look at the same record from the join
query, the zip code is listed twice with the same date and time stamp.

I am at a loss as to why the records are being duplicated.

Thanks,
Mike
 
I'm sorry to have posted this. I reviewed both tables and noticed there are
duplicate entires in TableB causing the duplicate output. Thanks.
 
Back
Top