combining tables

[ryanbrand]

Hi,
I have an updating issue with my one of my database tables. I have an old table with fields that are accurate, except for one of the fields. I have another table that has the same records (plus many more) with the correct information in the field that is outdated in the other table, but doesn't have any other information. Both the tables have the primary keys.

I'm using an Access Database. How could I update my records? There are sample tables below to help explain.

Thank you for your help.

Ryan

OldTable
ID First Last Counselor
1 Sam Kin Jim
2 Jill Smith Mary
3 James Carls Ginger


NewTable
ID NewCounselor
1 Kirt
2 Jacky
3 Mark
4 Barb
45 Nick
54 Terry

 

[r937]

[tt]update OldTable
inner
join NewTable
on OldTable.ID = NewTable.ID
set OldTable.Counselor
= NewTable.NewCounselor[/tt]


rudy

http://r937.com/

SQL Consulting

 

[ryanbrand]

Thanks Rudy. That worked perfectly.

Ryan