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; |
