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
|
SELECT t1.cellid_start,
t3.celllac as col1,
t3.cell as col2,
t3.nodeb as col3,
t3.rnc as col4,
t3.longitude as col5,
t3.latitude as col7,
t3.name as col8,
NULL as col9,
NULL as col10,
NULL as col11,
NULL as col12,
NULL as col13,
NULL as col14,
NULL as col15
FROM kpi.connexion_dwhs t1, kpi.cell3g t3
WHERE t1.name2 = 21652951596 AND T1.CELLID_START = T3.CELLID
UNION
SELECT t1.cellid_start,
NULL as col1,
NULL as col2,
NULL as col3,
NULL as col4,
NULL as col5,
NULL as col7,
NULL as col8,
t2.celllac as col9,
t2.cell as col10,
t2.bsc as col11,
t2.msc as col12,
t2.longitude as col13,
t2.latitude as col14,
t2.nom as col15
FROM kpi.connexion_dwhs t1, kpi.cell2g t2
WHERE t1.name2 = 21652951596 AND t1.cellid_start = T2.CELLID |
Partager