1 2 3 4 5 6 7 8 9 10 11 12 13
| select distinct 3, numgttrc, intgttrc, appgttrc, intgtapp, nvl(catgttrc, 'SANS'), null
from gttrc rc, gtapp pp, gttrd rd
where pp.numgtapp=rc.appgttrc
and rc.numgttrc=rd.trcgttrd
union select distinct 1, null, null, numgtapp, intgtapp, null, null
from gttrc rc, gtapp pp, gttrd rd
where pp.numgtapp=rc.appgttrc
and rc.numgttrc=rd.trcgttrd
union select distinct 2, null, null, numgtapp, intgtapp, nvl(catgttrc, 'SANS'), null
from gttrc rc, gtapp pp, gttrd rd
where pp.numgtapp=rc.appgttrc
and rc.numgttrc=rd.trcgttrd
order by 1, 5, 4, 6, 2 |
Partager