select ds.ArchROR,k.Konto,ds.*
from fktdowodyksSzcz ds INNER JOIN fktPlanKont k on ds.UID_fktPlanKont=k.UID
where k.RokObr='2009' AND k.Jk=1 AND ((k.Rozrachunki=2) OR (k.Rozrachunki=3)) AND (ds.ArchROR=1)




UPDATE fktdowodyksSzcz SET ArchROR=1, WskTriger=1 WHERE UID IN
(select ds.UID
from fktdowodyksSzcz ds INNER JOIN fktPlanKont k on ds.UID_fktPlanKont=k.UID
where k.RokObr='2009' AND k.Jk=1 AND ((k.Rozrachunki=2) OR (k.Rozrachunki=3)) AND (ds.ArchROR=1))