select
doc.stat,
doc.name,
doc.caption,
doc.date,
num.sum,
sum(all.beg),
sum(all.end)
from doc
inner join num on doc.id=num.id
left join all on num.id=all.id
where
doc.caption='работает'
and doc.date=(select max(DD.date)from doc DD where DD.name='все'
and DD.caption='работает'

WITH ALL_SUM AS (
  SELECT ALL.ID AS ID,
         SUM(ALL.BEG) AS SUM_BEG,
         SUM(ALL.END) AS SUM_END
  FROM ALL
  GROUP BY 1
)
SELECT
    DOC.STAT,
    DOC.NAME,
    DOC.CAPTION,
    DOC.DATE,
    NUM.SUM,
    ALL_SUM.SUM_BEG,
    ALL_SUM.SUM_END
FROM DOC
INNER JOIN NUM ON DOC.ID = NUM.ID
LEFT JOIN ALL_SUM ON NUM.ID = ALL_SUM.ID
WHERE DOC.CAPTION = 'работает' AND
      DOC.DATE = (SELECT
                      MAX(DD.DATE)
                  FROM DOC DD
                  WHERE DD.NAME = 'все' AND
                        DD.CAPTION = 'работает')

select
document.doc_status,
document.objectname,
document.doc_caption,
document.doc_date,
num_mv.outsum,
sum(mv_all.sum_beg) as sum1,
sum(mv_all.sum_end) as sum2
from num_mv 
inner join document on num_mv.id=document.id
left join mv_all on document.id=mv_all.id
where
document.doc_caption='Выполнен'
and document.objectname,='num_mv'
and document.doc_date=(select max(dd.doc_date) from document dd where dd.objectname='num_mv'
and dd.doc_caption='Выполнен')
group by outsum, 
doc_status,
objectname,
doc_caption,
doc_date

WITH ALL_SUM AS (
  SELECT ALL.ID AS ID,
         SUM(ALL.BEG) AS SUM_BEG,
         SUM(ALL.END) AS SUM_END
  FROM ALL
  GROUP BY 1
)
SELECT
    DOC.STAT,
    DOC.NAME,
    DOC.CAPTION,
    DOC.DATE,
    NUM.SUM,
    ALL_SUM.SUM_BEG,
    ALL_SUM.SUM_END
FROM DOC
INNER JOIN NUM ON DOC.ID = NUM.ID
LEFT JOIN ALL_SUM ON NUM.ID = ALL_SUM.ID
WHERE DOC.CAPTION = 'работает' AND
      DOC.DATE = (SELECT
                      MAX(DD.DATE)
                  FROM DOC DD
                  WHERE DD.NAME = 'все' AND
                        DD.CAPTION = 'работает')