UPDATE Sklad INNER JOIN SodergPokup ON Sklad.LinkTovar = SodergPokup.LinkTov SET Sklad.kol = [kol]-[Kolvo1] WHERE (((SodergPokup.LinkPokup)=[X]));