compare zips between 2 tables/insert
Posted on 2006-10-26
Ok, I'm trying to do the following:
I have a table called zipTable holding 4 fields:
code zip roundrobin counter (header)
abcd 80001 2 0
adfr 80002 4 0
etrg 80003 12 0
hjuy 80004 0 0
qwse 80005 3 0
Now I import a csv file into a table called csvTable:
I want to compare zips (each record) in csvTable with zips in zipTable.
Now if any zips in the csvTable matches a zip in zipTable, I need to insert the string in field code in zipTable into that record in csvTable.
This is the first of several. Thanks for your input and help.