Appending Field and data into Table

[papafredo]

I have two tables with 3 fields - first name, last name, email address. Table 1 is the clean list but has no data under "last name". Table 2 is the master list which has data in the "last name" field. How do I append the "last name" data in Table 2 into the "last name" field in table 1?

 

[grega]

I'll assume that email address is the key field on both tables. If so then you can do ...

update t1
set t1.lastname = t2.lastname
from table1 t1, table2 t2
where t1.email_address = t2.email_address

Greg.