- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
SELECT 'январь' mes, a.datogt, gr.date_ogt datogt_, a.id_grafik,
a.date_ogt dat_zam, 0 pr_zam, TO_CHAR(gr.date_ogt, 'DD') dat_zam_,
0 pr_zam_, a.date_inp dat_nach, 0 pr_nach,
TO_CHAR(gr.date_inp, 'DD') dat_nach_, 0 pr_nach_
FROM (SELECT id_grafik, TO_CHAR(date_inp, 'DD') date_inp,
TO_CHAR(date_ogt, 'DD') date_ogt, date_ogt datogt, god,
TO_CHAR(date_ogt, 'MM') mon
FROM protokol p
WHERE god = p_god
AND TO_NUMBER(TO_CHAR(date_inp, 'MM')) = 01
AND pr_protokol = 1
AND flag_a = 1) a
INNER JOIN protokol gr
ON gr.god = a.god
AND TO_CHAR(gr.date_ogt, 'mm') = a.mon
AND gr.pr_protokol = 2
AND flag_a = 1