Update Query-two tables

[AmyLynnHill]

Does anyone know how to use an update query however, rather than update the field with a specific value, the field is updated from another tables value of the same field name?

This is the sql I attempted to use however, when I execute the statement i get a enter parameter value when it gets to the Where statement?

Any advise would be greatly appreciated, I'm lost!

Update PendingPolicies
Set PendingPolicies.PolicyStatus = PolicyTable.PolicyStatus
Where PendingPolicies.PolicyNumber=PolicyTable.PolicyNumber----Iknow there appears to be a space here but there is not in my SQL?

 

[FoFa]

TRY:
Update PendingPolicies
Set PendingPolicies.PolicyStatus = PolicyTable.PolicyStatus
FROM PolicyTable
Where PendingPolicies.PolicyNumber=PolicyTable.PolicyNumber