Parcell'air

Extraction des adresses

select keypar, ccovoi, ccoriv, rivoli.covoie, clefvoie, natvoie, libvoie,annulation,dtannu, dtcrea, typvoie, dermot,
CONCAT(rivoli.ccocom,rivoli.covoie) "CODRIVOL"
from majic_05000.parcelle10 as parcelle, majic_05000.rivoli as rivoli
where parcelle.ccoriv=rivoli.covoie

Liste des rues

select rivoli.covoie, clefvoie, natvoie, libvoie,annulation,dtannu, dtcrea, typvoie, dermot,
CONCAT(rivoli.ccocom,rivoli.covoie) "CODRIVOL"
from majic_05000.rivoli as rivoli