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 43 44 45 46 47 48
| SELECT
MAD_LTS.Serv_Alias1 AS [N° Liaison Commerciale],
Null AS [N° Eqpt 1],
Right([MAD_LTS].[Site1],Len([MAD_LTS].[Site1])-7) AS [Nom Site 1],
Left([MAD_LTS].[Site1],6) AS [N° Site 1],
Null AS [Nom Faisceau 1],
Null AS [N°Accès Physique 1],
Null AS [AFLR 1],
Null AS Usage1,
MAD_LTS.[Noeud1],
MAD_LTS.Port1,
Null AS [N° Eqpt 2],
Right([MAD_LTS].[Site2],Len([MAD_LTS].[Site2])-7) AS [Nom Site 2],
Left([MAD_LTS].[Site2],6) AS [N° Site 2],
Null AS [Nom Faisceau 2],
Null AS [N°Accès Physique 2],
Null AS [AFLR 2],
Null AS Usage2,
MAD_LTS.[Noeud2],
MAD_LTS.Port2
FROM [006-002-1379] LEFT JOIN MAD_LTS ON [006-002-1379].[N° Liaison Commercial] = MAD_LTS.Serv_Alias1
UNION
SELECT
MAD_CLD.Serv_Alias1 AS [N° Liaison Commerciale],
Null AS [N° Eqpt 1],
Right([MAD_CLD].[Site1],Len([MAD_CLD].[Site1])-7) AS [Nom Site 1],
Left([MAD_CLD].[Site1],6) AS [N° Site 1],
Null AS [Nom Faisceau 1],
Null AS [N°Accès Physique 1],
Null AS [AFLR 1],
Null AS Usage1,
MAD_CLD.[Noeud1],
MAD_CLD.Port1,
Null AS [N° Eqpt 2],
Right([MAD_CLD].[Site2],Len([MAD_CLD].[Site2])-7) AS [Nom Site 2],
Left([MAD_CLD].[Site2],6) AS [N° Site 2],
Null AS [Nom Faisceau 2],
Null AS [N°Accès Physique 2],
Null AS [AFLR 2],
Null AS Usage2,
MAD_CLD.[Noeud2],
MAD_CLD.Port2
FROM [006-002-1379] LEFT JOIN MAD_CLD ON [006-002-1379].[N° Liaison Commercial] = MAD_CLD.Serv_Alias1; |
Partager