vbnetcoder
asked on
sql query access
When i run this query i get a missing operator error. Why?
Update Table_1
SET Table_1.[Spend Purpose - Primary] = Table_2.[New Value]
FROM Table_1
INNER JOIN Table_2 ON (Table_1.[Spend Nature or Type] = Table_2.[Spend Nature])
AND (Table_1.[Spend Purpose - Primary] = Table_2.[Spend Purpose])
Update Table_1
SET Table_1.[Spend Purpose - Primary] = Table_2.[New Value]
FROM Table_1
INNER JOIN Table_2 ON (Table_1.[Spend Nature or Type] = Table_2.[Spend Nature])
AND (Table_1.[Spend Purpose - Primary] = Table_2.[Spend Purpose])
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ty
SET Table_1.[Spend Purpose - Primary] = Table_2.[New Value]?