Adding columns given a match

Giganews Newsgroups
Subject: Adding columns given a match
Posted by:  Cefoxtrot
Date: Thu, 26 Mar 2009


I have 2 tables with different data, except for a member ID column.

Table A has 38,000 records with about 35 columns. Table B has 3,000 records,
with about 9 columns.
I need to read table B, scan table A with the member ID from table B and add
the 3 last cells from table B to table A for that member.

I have a general idea how to do it, but that's about it. I need help.
Any suggestions will be greatly appreciated.
Thanks much in advance,