<msnews.microsoft.com> wrote in message
news:%23RdGt2WYEHA.3420@TK2MSFTNGP12.phx.gbl...
> I have 2 tables...
>
> table1
> -------
> col1
> col2
> col3
> col4
> col5
> col6
>
> table2
> -------
> col1
> col2
> col3
> col4
> col5
> col6
>
> I have data in table 1 that I need to delete from table2 ONLY where col1,
> col2, and col3 are the exact same in col1,col2,col3 in table2. Then I
need
> to insert all rows from table1 into table2 where I just deleted that data
> from table2. The remaining data in the other colums may be different, I
> just need to do a compare on those 3 columns then insert the entire
rows...
> kinda like doing an update/insert where multiple columns match.
>
> Any ideas?
>
> Thanks a lot.
>
>

wrote:

>DELETE FROM Table2 WHERE EXISTS
>(
> SELECT * FROM Table1 T1 WHETE T1.col1=Table2 .col1 AND T1.col2=Table2 .col2
>AND T1.col3=Table2 .col3
>)
>
>INSERT INTO Table2 SELECT * FROM Table1 WHERE NOT EXISTS (SELECT * FROM
>Table2 T2 WHETE T2.col1=Table1 .col1 AND T2.col2=Table1 .col2 AND
>T2.col3=Table1 .col3)