Update based on lookup table

[Juzam55]

I have a table of mappings of various codes, tbl_Map with fields
mapID, code1 and code2

I need to write and Update command that for each row in tbl_Map
updates another table's, tbl_Codes, "code" field with code2 where it =
code1

So in the end, tbl_Codes contain codes based on the mapping rules in
tbl_Map.

I really have no clue how to write this, so any help anyone could
provide would be great!

[Squirrel]

Hi there,

Here's the Query for you:

UPDATE tbl_Codes INNER JOIN tbl_Map ON tbl_Codes.code = tbl_Map.code1 SET
tbl_Codes.code = [tbl_Map].[code2];

HTH -Linda

"Juzam55" <ju*****@aol.com> wrote in message
news:75**************************@posting.google.c om...

I have a table of mappings of various codes, tbl_Map with fields
mapID, code1 and code2

I need to write and Update command that for each row in tbl_Map
updates another table's, tbl_Codes, "code" field with code2 where it =
code1

So in the end, tbl_Codes contain codes based on the mapping rules in
tbl_Map.

I really have no clue how to write this, so any help anyone could
provide would be great!