SELECT
-- identifiant du local00,local10
A.ccosec, A.dnupla, A.invar, A.dnubat, A.descr, A.dpor,
D.dteloc_lib AS Type, E.cconlc_lib AS Nature,
C.dnupro,B.jdatat AS mutation,
--PEV
F.ccoeva_lib, pev.dvlper,
B.cc48lc, B.dloy48a, B.top48a,
--Propriétaire nom et prénom d'usage
C.ddenom, C.epxnee, C.dnomcp, C.dprncp,
-- adresse du propriétaire
C.dlign3,C.dlign4,C.dlign5,C.dlign6,
-- Affectation du local (pev)
G.ccoaff_lib, H.detent, pev.dsupot, pev.dcapec,
pev.dvlper, pev.dvlpera
FROM local00 AS A
INNER JOIN local10 AS B ON B.invar = A.invar
INNER JOIN proprietaire AS C ON C.comptecommunal = B.comptecommunal
INNER JOIN dteloc AS D ON D.dteloc = B.dteloc
INNER JOIN cconlc AS E ON E.cconlc = B.cconlc
INNER JOIN ccoeva AS F ON F.ccoeva = B.ccoeva
INNER JOIN pev ON pev.local10 = B.local10
INNER JOIN ccoaff AS G ON G.ccoaff = pev.ccoaff
INNER JOIN pevprincipale AS H ON H.invar = A.invar
INNER JOIN pevtaxation AS M ON M.dnupev = pev.dnupev
WHERE A.ccosec = "AP" AND A.dnupla = "0109"
Liens sociaux