Updating records with SQL statement that are in 2 diff. tables not working.

Question

This is my SQL Statement

UPDATE sysdba.CONTACT, sysdba.ADDRESS
SET sysdba.ADDRESS.Address1 = '123 Tech Parway'
WHERE sysdba.CONTACT.AddressID = sysdba.ADDRESS.AddressID
AND sysdba.CONTACT.contactID = 'CRBD'

What is wrong here?

Thanks in advanced!

EDIT: Using SQL Server 2005

Answer 1

I can't see any problem with this syntax according to MySQL UPDATE command reference. Maybe you're getting errors from MSSQLServer? Could you supply the errors for further investigation?

Answer 2

TSQL solution

UPDATE sysdba.ADDRESS
SET Address1 = '123 Tech Parway'
FROM sysdba.ADDRESS
INNER JOIN sysdba.CONTACT 
    ON sysdba.CONTACT.AddressID = sysdba.ADDRESS.AddressID
WHERE sysdba.CONTACT.contactID = 'CRBD'