I have 2 tables...

Table1:  FullName, City, State, Data1
Table 2:  FullName, City, State, Data1, Data2, Data3

This is what I want to do...
1.  For every record that is in BOTH tables I want to UPDATE TABLE 2 with
the data from Table 1.
2.  Then, if there are "extra"/new records in table 1 I want to append them
to Table 2.

How do I do this in SQL?

Thanks.