Update table problem

here is my query which I want it to update the secretNO1 coulmn in firstterm table automatically when it's value entered in table studentdata , when I run it , it make noooooo changes

There is a relationship 1 to 1 between them

update FirstTerm
set SecretNO1 = StudentData.SecretNO1
from StudentData
inner join FirstTerm on FirstTerm.SettingID=StudentData.SettingID where StudentData.SettingID <> null


Please where is the problem??

Thanks for your response but it doesn't work .

Just saying that it does not work will not assist anyone trying to help you.

when I try to run this query it give me message that "0 rows was affected by this query" but it must give me there are number of rows was affected as they meet the criteria

thnx