Merging information

  • Thread starter Thread starter Dorothy
  • Start date Start date
D

Dorothy

I have 2 tables with one field that is the same (SS#).
In Table 1 I have 2 fields (BU and Matric) that I'd need
to get into Table 2, but only where the SS#s match. (So in
the end, some of the records in Table 2 will not have info
in these 2 fields). How do I accomplish this? I
appreciate your help. Thanks.
 
How about this?
****************************
UPDATE table1 INNER JOIN Table2 ON table1.ssn = Table2.ssn SET Table2.bu =
[Table1.bu], Table2.matric = [Table1.matric];
******************************
Assuming that both Table1 and Table2 have fields called ssn (Social Security
Number), bu, matric.

Sal
www.cedrostec.com
 
Back
Top