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 id in
(
select nakup.id
from nakup
inner join zakaznik on nakup.zakaznik_id=zakaznik.id
where zakaznik.skupina_id='1'
)