Update only certain records

[Gideon Engelbrecht]

I only want to update records where oesjaar = current year. Oesjaar is of type YEAR in my table. When I run the following query all records are updated. Those where oesjaar <> year(curdate()) is set to NULL. The rest where oesjaar = Year(curdate()) are correct.


update pryse
set noemklas =(select klasbeskrywing from klasse
where pryse.oesjaar = year(curdate()) and
pryse.klas = klasse.klaskode);



Should I be using a nested query?