I have 2 tables, "tblJob" and "tblRegion".

tblJob tblRegion
====== M---1 =======
Job_PK Reg_PK
Reg_FK Reg_Name
Reg_Name

tblJob has a list of jobs and a foreign key pointing to the tblRegion which holds a list of all regions/cities e.t.c.

I have to somehow get the Reg_Name from tblRegion into Reg_Name in tblJob. I know this defeats the objective but I hHAVE to do it.

I have hundreds of records and I have no idea as to the syntax of the update query required.

Can anyone help ?

TIA