Update Query with Inner Join 1

[jmcg]

I have tried to run the following query on my SQL database:
UPDATE EnqData
INNER JOIN [SCARS] ON EnqData.SAC = [SCARS].SAC
SET EnqData.CYTD = [scars].[CYTD]
and this fails as an error near the word inner.
Any help? Where am I going wrong.

 

[tlbroadbent]

The proper syntax is.

UPDATE EnqData
SET EnqData.CYTD = [scars].[CYTD]
FROM EnqData
INNER JOIN [SCARS]
ON EnqData.SAC = [SCARS].SAC

Terry Broadbent
Please review faq183-874.

"The greatest obstacle to discovery is not ignorance -- it is the illusion of knowledge." - Daniel J Boorstin