Lookup data in one table and move to another 1

[WaveOut]

I need help with the following:

I have two tables. The first table, Craft_temp, contains the following fields:

craftID craft_group craft_name craft_cateogry
1 1 Carpenter A Carpenter
2 2 Carpenter B Carpenter
3 1 Electrician A Electrician


My other table, Craft, contains the following fields:

craftID craft_group craft_name craft_cateogry
1 Null Carpenter A Carpenter
2 Null Carpenter B Carpenter
3 Null Electrician A Electrician


My goal is to get rid of the Null's in the craft_group field. I'm thinking I need to lookup the craft_name in the craft_temp table and get the craft_group and copy it to the craft table. I'm just not sure how to write this in sql. Any help is appreciated.

Thanks,
Dave

 

[RiverGuy]

UPDATE a
SET a.craft_group = b.craft_group
FROM Craft a, Craft_temp b
WHERE a.craftID = b.craftID

 

[WaveOut]

RiverGuy,
Thanks! works great!

Dave