update nakup
set spracovane_skupina='1'
where id in
(
select nakup.id
from nakup
inner join zakaznik on nakup.zakaznik_id=zakaznik.id
where zakaznik.skupina_id='1'
)

update nakup
set spracovane_skupina='1'
where zakaznik_id in
(
select id from zakaznik where skupina_id='1' and id is not null
)