Filling Table B with certain fields from Table A

[nkomokov]

I'm not quite sure how to do this...

I have Table A which has 100,000 records but no names and I have Table B which is made up of 30,000 records previously pulled from Table A and manually filled in Name fields, but whoever pulled it forgot to pull the ZipCode field, so now I need to populate the ZipCode field on Table B with the ZipCode field on Table A, but matching the records using the Address field.

 

[nkomokov]

NEVER MIND. I figured it out. It wasn't very hard, I just got it in my head that it was going to be complex.

Thanks!

 

[aajaydee]

can you share with us how did you figure it out