1 2 3 4 5 6 7 8 9 10 11 12
|
SELECT "INFRACTION"."NUMCONSTAT", "INFRACTION"."NOM", "INFRACTION"."DATCONSTAT", "INFRACTION"."DAT1EMIS", "INFRACTION"."DAT1RET", "INFRACTION"."DAT2EMIS", "INFRACTION"."DAT2RET", "INFRACTION"."DAT3EMIS", "INFRACTION"."DAT3RET", "INFRACTION"."DATENQEMIS", "INFRACTION"."DATENQREP", "INFRACTION"."DATCONEMIS", "INFRACTION"."DATCONREP", "INFRACTION"."DATM2EMIS", "INFRACTION"."DATM2REP", "INFRACTION"."DATP2EMIS", "INFRACTION"."DATP2REP", "INFRACTION"."DATPROEMIS", "INFRACTION"."MOTIF", "INFRACTION"."INDBLOC"
FROM "STRD_ADMIN"."INFRACTION" "INFRACTION"
WHERE INFRACTION."NUMCONSTAT" IN
(SELECT INFRACTION."NUMCONSTAT"
FROM
"STRD_ADMIN"."INFRACTION" INFRACTION
MINUS
SELECT INFPAI."NUMCONSTAT" FROM "STRD_ADMIN"."INFPAI" INFPAI)
AND INFRACTION."DATABANDON" IS NULL
AND INFRACTION."DATANNUL" IS NULL
ORDER BY "INFRACTION"."NUMCONSTAT" |
Partager