17,140
社区成员




select replace((wm_concat(decode((select C.GSMDCSINDICATOR -- 这里加个 decode 函数
from T_JL_RADIO_CELL A,
T_JL_RADIO_CELL B,
T_COM_LOGIC_RADIO_CELL C
where A.Sitecode = B.SITECODE
and B.Cuid = C.Cuid
union
select D.SITE_CATEGORY
from T_JL_RADIO_CELL A,
T_JL_RADIO_ECELL B,
T_COM_LOGIC_RADIO_ECELL D
where A.Sitecode = B.SITECODE
and D.Cuid = B.CUID),
'1',
'2G',
'2',
'2D',
'3',
'2G2D',
'4',
'FG',
'5',
'FD',
'6',
'7',
'LE',
'8',
'LD',
'9',
'10',
'NB'))), -- 这里加个 )
',',
'+')
from T_JL_RADIO_CELL A,T_JL_RADIO_CELL B,T_COM_LOGIC_RADIO_CELL C,T_COM_LOGIC_RADIO_ECELL D