1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| RSA:
Load Index_RSA as rsaID,
mois_sortie as rsaMoisSortie,
annee_sortie as rsaAnSortie,
FINESS as rsaEtab,
Nature as rsaNature,
Codes as rsaCodes
from ...
Join LOad FINESS as rsaEtab,
Raison_sociale as rsaRaisSoc
resident Etablissements
Join LOad Codes as rsaCodes,
Libellé as rsaLibCodes
resident THS_CIM10
RUM:
Load Index_RSA as rsaID,
Index_RUM as rumID,
FINESS as rumEtab,
Nature as rumNature,
Codes as rumCodes
from ...
Join LOad FINESS as rumEtab,
Raison_sociale as rumRaisSoc
resident Etablissements
Join LOad Codes as rumCodes,
Libellé as rumLibCodes
resident THS_CIM10 |
Partager