would you mind looking at this UPDATE command?

[Durand Graves]

UPDATE
tbl_w_testdata,
tbl_w_testdata_NEW
SET
tbl_w_testdata.data_iv_header=tbl_w_tesdata_NEW.data_iv_header,
tbl_w_testdata.data_iv_col1=tbl_w_tesdata_NEW.data_iv_col1,
tbl_w_testdata.data_iv_col2=tbl_w_tesdata_NEW.data_iv_col2,
tbl_w_testdata.data_iv_col3=tbl_w_tesdata_NEW.data_iv_col3,
tbl_w_testdata.data_iv_col4=tbl_w_tesdata_NEW.data_iv_col4,
tbl_w_testdata.iv_date_created=tbl_w_tesdata_NEW.iv_date_created

WHERE
tbl_w_testdata.w_name=tbl_w_testdata_NEW.w_name
AND
tbl_w_testdata.w_subsite_id=tbl_w_testdata_NEW.w_subsite_id



gives me this error


#1064 - You have an error in your SQL syntax near '
tbl_w_testdata_NEW
SET
tbl_w_testdata.data_iv_header=tbl_w_tesdata_NEW.dat' at line 2


Any ideas? What am I overlooking?

TIA,

Durand