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
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