update query

[iren]

I have to two tables . DATA table has 720 records while Data_frsrt table has 513 records
They have majority of the same fields. Except DATA has 5 more fields
I need to merge both tables by QID in order to update all filelds values in DATA with values from DATA_first table for the same QID while all other records value should stay the same
I did update query based on both tables right outer join in order the table have 720 records. I used build to update each filed of Data table with Data_frsrt’ value

When I try to run my update query system generate a message: too many fields defined.
I have not more than 150 fields (even considering 145 fields from data-first table which I use for update.

What I am doing wrong?

 

[lameid]

You should proably repost in the query forum... forum701

Also when you do, you should post your SQL as without the SQL nothing is occuring to me.

Naturally abridge the set portion of your statement with the same note on the number of fields.