I have an update statement which works in Access. Now I am moving to SQL Server and trying to modify the statement, but so far without luck. What am I doing wrong?
Here the Access statement:
UPDATE MyTable INNER JOIN YourTable ON MyTable.ID = YourTable.ID SET MyTable.NAME = [YourTable]![NAME], MyTable.ADDRESS = [YourTable]![ ADDRESS]
Here my new modified for SQL Server statement.
SET MyTable.NAME = YourTable.NAME, MyTable.ADDRESS = YourTable. ADDRESS
WHERE MyTable.ID = YourTable.ID