SQL Update Question

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.

RobinS
Sat May 10 00:43:53 CDT 2008

You could post your question to the SQLServer programming newsgroup...

RobinS.


"Cirene" <cirene@nowhere.com> wrote in message
news:OKegtTTsIHA.3604@TK2MSFTNGP03.phx.gbl...
>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.
>