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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
|
SELECT T_LIB_PAYS
, T_NOM_REGION
, NT_NUM_DEPT
, T_NOM_DEPT
, NT_CP_VILLE
, T_NOM_VILLE
, N_COORD_X
, N_COORD_Y
FROM dbo.TB_GEO_VILLES tgv
INNER JOIN dbo.TB_GEO_VILLES_LG tgvl
ON tgv.I_VILLE = tgvl.I_VILLE_FKPK
INNER JOIN (
SELECT I_PAYS
, T_LIB_PAYS
, I_REGION
, T_NOM_REGION
, I_DEPARTEMENT
, NT_NUM_DEPT
, T_NOM_DEPT
FROM dbo.TB_GEO_DEPARTEMENTS tgd
INNER JOIN dbo.TB_GEO_DEPARTEMENTS_LG tgdl
ON tgd.I_DEPARTEMENT = tgdl.I_DEPARTEMENT_FKPK
INNER JOIN (
SELECT I_PAYS
, T_LIB_PAYS
, I_REGION
, T_NOM_REGION
FROM dbo.TB_GEO_REGIONS tgr
INNER JOIN dbo.TB_GEO_REGIONS_LG tgrl
ON tgr.I_REGION = tgrl.I_REGION_FKPK
INNER JOIN (
SELECT I_PAYS
, T_LIB_PAYS
FROM dbo.TB_GEO_PAYS tgp
INNER JOIN dbo.TB_GEO_PAYS_LG tgpl
on tgp.I_PAYS = tgpl.I_PAYS_FKPK
WHERE I_LANGAGE_FKPK = 1 ) rqPAYS
ON tgr.I_PAYS_FK = rqPAYS.I_PAYS
WHERE tgrl.I_LANGAGE_FKPK = 1 ) rqPAYSREGION
ON tgd.I_REGION_FK = rqPAYSREGION.I_REGION ) rqPAYSREGIONDEPT
ON tgv.I_DEPARTEMENT_FK = rqPAYSREGIONDEPT.I_DEPARTEMENT; |
Partager