How to correctly set a query in SQL Server according to the available data?

Question

MySQL

update Cred_zaborg
set Suma_zaborg=Suma_zaborgVAL*Valuta.Kurs
Error:
Msg 4104, Level 16, State 1, Line 3
The multi-part identifier "Valuta.Kurs" could not be bound.

Answer 1

I don’t see the picture :( you need to select the Valuta.Kurs value in some variable and then use it in update