SQL Query not working 1

[phil22046]

I have an update query I need to run one time:

UPDATE memaddr
SET {memaddr.Address1 = Temp_NonDPV_Batch.Address1,
memaddr.Address2 = Temp_NonDPV_Batch.Address2,
memaddr.city = Temp_NonDPV_Batch.city,
memaddr.state = TEMP_NonDPV_Batch.state,
memaddr.zip = Temp_NonDPV_Batch.zip }
from Temp_NONDPV_Batch
INNER JOIN memaddr
ON memaddr.memid = Temp_NonDPV_Batch.Memid
WHERE memaddr.preferred in (-1,1)

I get this error message in query analyzer and don't know what I am doing wrong.

[Microsoft][ODBC SQL Server Driver]Syntax error or access violation

Can somebody explain this so I can get unstuck please?

 

[SQLDenis]

no brackets

UPDATE memaddr 
   SET memaddr.Address1 = Temp_NonDPV_Batch.Address1, 
        memaddr.Address2 = Temp_NonDPV_Batch.Address2,
        memaddr.city = Temp_NonDPV_Batch.city,
        memaddr.state = TEMP_NonDPV_Batch.state,
        memaddr.zip = Temp_NonDPV_Batch.zip 
   from Temp_NONDPV_Batch
  INNER JOIN memaddr
     ON memaddr.memid = Temp_NonDPV_Batch.Memid 
WHERE memaddr.preferred in (-1,1)

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions