2 table update query

[ed in aus]

Hi,



Have 2 tables and want to update the suburb field from 1 table to another, however when I run the code the table does not update

There are about 40k records to be updated

SQL code -

UPDATE TblMaster
INNER JOIN TblSub_State_Country ON TblMaster.Email = TblSub_State_Country.Email
SET TblMaster.suburb = [TblSub_State_Country].[suburb];

[CJ_London]

1. if you temporarily change to a select query - are records returned? i.e. can you confirm the join is working as expected?
2. do the two suburb fields have the same datatype and properties (i.e. both long or text of the same length)
3. and when you say 'does not update' - do you get a report saying '40000 records not updated because...'