1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
select count(1)
from
(
Select SDH.PRG_TRONCON_OPERATION.ID_PRG_TRONCON_OPERATION,
SDH.PRG_TRONCON_OPERATION.ROUTE,
SDH.PRG_TRONCON_OPERATION.LOCAL1,
SDH.PRG_TRONCON_OPERATION.LOCAL2,
SDH.PRG_TRONCON_OPERATION.OFFSET,
SDH.PRG_TRONCON_OPERATION.OFFSET_SIDE,
SDH.PRG_OPERATION.ID_PRG_LEX_SOUS_PROGRAMME, <-- il ne dit rien à cette ligne
SDH.PRG_OPERATION.ANNEE_OPERATION
from
(
(
(
SDH.PRG_TRONCON_OPERATION LEFT JOIN SDH.PRG_LEX_SOUS_PROGRAMME
/*Ligne 17:*/ON SDH.PRG_OPERATION.ID_PRG_LEX_SOUS_PROGRAMME = SDH.PRG_LEX_SOUS_PROGRAMME.ID_PRG_LEX_SOUS_PROGRAMME)
LEFT JOIN SDH.PRG_LEX_ETAT ON SDH.PRG_OPERATION.ID_PRG_LEX_ETAT = SDH.PRG_LEX_ETAT.ID_PRG_LEX_ETAT)
INNER JOIN SDH.PRG_OPERATION ON SDH.PRG_TRONCON_OPERATION.CODE_ITIN =SDH.PRG_OPERATION.CODE_ITIN)
where SDH.PRG_TRONCON_OPERATION.CODE_ITIN = SDH.PRG_OPERATION.CODE_ITIN
and SDH.PRG_OPERATION.ANNEE_OPERATION = 2011
order by SDH.PRG_TRONCON_OPERATION.ROUTE,SDH.PRG_TRONCON_OPERATION.LOCAL1) |
Partager