Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;


BANNER


Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

PL/SQL Release 11.2.0.2.0 - Production

CORE 11.2.0.2.0 Production

TNS for Linux: Version 11.2.0.2.0 - Production

NLSRTL Version 11.2.0.2.0 - Production


create table dc (id_document, comments) as
    select 1, 'comment 1' from dual
1 rows affected

create table st (id_document, dateend) as
    select 1, date'2021-07-15' from dual
1 rows affected

create table log (id_document, description, dateevent) as
    select 1, 'description 1', date'2021-07-01' from dual union all 
    select 1, 'description 2', date'2021-07-02' from dual union all 
    select 1, 'description 3', date'2021-07-03' from dual 
3 rows affected

select dc.*, st.dateend, log.description, log.dateevent
from dc
join st on st.id_document = dc.id_document
join (
    select id_document, 
    max (description) keep (dense_rank last order by dateevent asc) description,
    max (dateevent)   keep (dense_rank last order by dateevent asc) dateevent
    from log l
    group by l.id_document) log on log.id_document = st.id_document
order by dc.id_document


ID_DOCUMENT
COMMENTS
DATEEND
DESCRIPTION
DATEEVENT


1
comment 1
15-JUL-21
description 3
03-JUL-21