I have been having problems with what I thought was an easy update query, using the following query, and the error prompt simply says it cannot update database. I have tested this code many times trying to run an update query to replace existing staging table values with mapped values. Appreciate it if anyone can help.
The SQL Code is as follows:
SET stgOutcomeDataUpload.SPassABC = (SELECT lkpStage4FieldMappings.FieldValue
FROM lkpStage4FieldMappings, stgOutcomeDataUpload
WHERE stgOutcomeDataUpload.SPassABC = lkpStage4FieldMappings.FieldString AND (((lkpStage4FieldMappings.FieldName)="SPassABC")));