Update Query is not working

[sg2808]

The update query is not working and I cannot understand why. I have attached the screenshots with SQL and Design view.

SQL -

UPDATE DetProcess INNER JOIN RiskDetailsTable ON DetProcess.DetProcessID = RiskDetailsTable.DetProcessID SET RiskDetailsTable.DetProcessID = [DetProcess].[DetProcessID];

Kindly advise.

Many thanks,
SG

[NeoPa]

How can you tell if it's working on not? You're setting the value to exactly what it must already be to qualify to be updated at all o.O

PS. If you post pictures as JPEGs we can see them. I'm just working from the SQL.