1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
|
with TEMPINIT as(
select
B.KEY theKey,
MAX(F.DATEMODIFICATION) dateMax
from user.data B,user.journal F
where F.ID=B.JOURNALID
group by
B.KEY,
F.DOCUID),
TEMPINIT2 as(
select
B.KEY,
B.VALUE,
B.DATEEMISSION,
B.FLAG,
F.DOCUID,
F.DATEMODIFICATION datemodif
from user.data B,user.journal F,TEMPINIT G
where B.KEY=G.theKey and F.DATEMODIFICATION=G.dateMax
and F.ID=B.JOURNALID
Order by F.DOCUID desc)
update user.DATA T
set T.FLAG=2
where T.JOURNALID in (select J.ID from user.JOURNAL from user.JOURNAL J inner join user.DATA T on T.JOURNALID=J.ID where J.DATEMODIFICATION not in (select temp.datemodif from TEMPINIT2 temp)) |
Partager