Assistance with SQL

[Aaron Burnett <aburnett@xxxxxxxxxxxx>]

Title: Assistance with SQL

Hi,

I’m hoping someone can help me out on this one.

Two tables

table1 has 25 columns
table2 is a subset of table1 (create table2 as select id,field1,field2,field3,field4,field5,field6 from table1) with just 7 columns
There is a primary key on ID 

table2 was exported to a CSV, truncated, then the “cleaned” CSV was re-imported to table2

In a nutshell I need to find the difference between the 6 columns in table2 vs table1 and update table1, again, with the ID column being the pk.


Thanks in advance for any help here.