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 26
|
select
o.qt_tm
from
dossier d , oper_commerciale o
where d.num_dossier in (select
distinct(d.num_dossier)
from
dossier d , oper_commerciale o ,navire n
where
n.ref_navire=d.ref_navire
and o.code_nature in (1,2,3,9 )
and d.date_bl>='01/01/2008'
and d.date_bl<='31/12/2008'
and o.num_dossier=d.num_dossier
and o.code_tier=83
and d.code_cns in (select c.code_cns from concess c
where c.lib_con='XXX')
)
and o.code_nature in (1)
and o.num_dossier=d.num_dossier
and o.code_tier=83
order by o.num_dossier |
Partager