SELECT T2.RELATED_BSCNAME AS BSC_NAME,
T2.bts AS BTS_ID,
T2.cell AS CELL_ID,
T2.CHINA_NAME AS BTS_NAME,
'' AS SUMDORTCH,
'' AS SUMDOFTCH,
'' AS SUMTIMES,
'' AS SUMSUC,
'' AS SUMEQU,
'' AS SPACE
FROM collect T1, cell T2
WHERE (T1.cellidone = T2.ne_sys_id OR T1.cellidtwo = T2.ne_sys_id OR
T1.cellidthree = T2.ne_sys_id)
AND T1.City_Id = T2.City_Id
AND T1.hot = '500046'
AND T1.dataproducetime = TO_DATE('2011-11-14', 'yyyy-mm-dd')
AND T1.CITY_ID IN (768)
AND T1.HP_TYPE IN ('学校')
GROUP BY T2.ne_sys_id, T2.RELATED_BSCNAME, T2.bts, T2.cell, T2.CHINA_NAME
T2.bts AS BTS_ID,
T2.cell AS CELL_ID,
T2.CHINA_NAME AS BTS_NAME,
'' AS SUMDORTCH,
'' AS SUMDOFTCH,
'' AS SUMTIMES,
'' AS SUMSUC,
'' AS SUMEQU,
'' AS SPACE
FROM collect T1, cell T2
WHERE (T1.cellidone = T2.ne_sys_id OR T1.cellidtwo = T2.ne_sys_id OR
T1.cellidthree = T2.ne_sys_id)
AND T1.City_Id = T2.City_Id
AND T1.hot = '500046'
AND T1.dataproducetime = TO_DATE('2011-11-14', 'yyyy-mm-dd')
AND T1.CITY_ID IN (768)
AND T1.HP_TYPE IN ('学校')
GROUP BY T2.ne_sys_id, T2.RELATED_BSCNAME, T2.bts, T2.cell, T2.CHINA_NAME
解决方案 »
- 关于dblink调用存储过程
- 请教这个sql怎么写?
- oracle92 sqlserver2000 dblink报错,求救!(tnsping成功)
- pl/sql 中将小数double型用to_char转换时返回结果去掉了前面的0
- ora00257 archiver error 数据库登录不了
- 盘符丢失后连接不到数据库了—应该是个难题
- oracle8.05,如何把专用设置服务器设置为多线程服务器?
- 那位大哥告诉一下PL/SQL developer5 正式版的下载地址(全的),和注册码! 100分
- oracle查询分页显示
- 【求助】oracle查询有关内容
- 如何使用游标值作为字段名称使用?具体如何写?
- 如何将一千亿的(从0到一千亿)有序数离散为随机数??急啊
AND T1.dataproducetime = TO_DATE('2011-11-14', 'yyyy-mm-dd')
AND T1.CITY_ID IN (768)
AND T1.HP_TYPE IN ('学校')这3个条件是在程序里面添加的。
没搞过执行计划。。 能不能给个多表的执行计划我看看?