• having a quick look I can't see how your update queries will work but that said:

    If there is more than one entry in Table 1 how do we identify what we should be using from table 2 to update in table 1?