SELECT a.prjid,a.PROJECTNAME,zhuzhai,shangye,(zongji-zhuzhai-shangye) qita FROM
(SELECT prjid ,PROJECTNAME,COUNT(*) zhuzhai FROM HOUSEWINDOW WHERE USAGE like '%住宅%' AND presaleid=0 AND SALEID!=2 AND MORTID<=0 AND LIMITID<=0 GROUP BY prjid,PROJECTNAME) a,
(SELECT prjid ,COUNT(*) shangye FROM HOUSEWINDOW WHERE USAGE like '%商业%' AND presaleid=0 AND SALEID!=2 AND MORTID<=0 AND LIMITID<=0 GROUP BY prjid) b,
(SELECT prjid ,COUNT(*) zongji FROM HOUSEWINDOW WHERE presaleid=0 AND SALEID!=2 AND MORTID<=0 AND LIMITID<=0 GROUP BY prjid) c,
project_more d
WHERE d.prjid=c.prjid
and b.prjid=c.prjid
and a.prjid=d.prjid
and d.STAT=1这里面,如果住宅与商业其中一项为空的话,那这个项目整个一条就出不来了.应该怎么办好呢?
(SELECT prjid ,PROJECTNAME,COUNT(*) zhuzhai FROM HOUSEWINDOW WHERE USAGE like '%住宅%' AND presaleid=0 AND SALEID!=2 AND MORTID<=0 AND LIMITID<=0 GROUP BY prjid,PROJECTNAME) a,
(SELECT prjid ,COUNT(*) shangye FROM HOUSEWINDOW WHERE USAGE like '%商业%' AND presaleid=0 AND SALEID!=2 AND MORTID<=0 AND LIMITID<=0 GROUP BY prjid) b,
(SELECT prjid ,COUNT(*) zongji FROM HOUSEWINDOW WHERE presaleid=0 AND SALEID!=2 AND MORTID<=0 AND LIMITID<=0 GROUP BY prjid) c,
project_more d
WHERE d.prjid=c.prjid
and b.prjid=c.prjid
and a.prjid=d.prjid
and d.STAT=1这里面,如果住宅与商业其中一项为空的话,那这个项目整个一条就出不来了.应该怎么办好呢?
解决方案 »
- select的问题
- 关于函数的使用。。。大家帮忙啊
- oracle 法语乱码问题,求解。。
- 发现oracle里取别名的一个奇怪现象
- 关于EM问题!!!
- 连接Oracle 10g时ORA-12514: TNS: 监听进程不能解析在连接描述符中给出的 SERVICE_NAME
- 数值类字段没有值的时候留NULL好还是写0好
- referencing new as n for each row 表示什么意思??
- 向高手们请教几个问题,关于存储过程和sql语句,谢谢!!!!!
- winProfessional,128内存,装oracle8。1。7能行吗
- jvm 进程退出,OCI连接方式,oracle 10.1,在线等
- 如何运用操作系统自带的工具监控在20个以上并发的时候,CPU和内存的平均占有率是否超过90%,oracle的库(分不够再给)
and c.prjid=b.prjid(+)
and c.prjid=a.prjid(+)
a.prjid=b.prjid(+)
and b.prjid=c.prjid(+)
and a.prjid=d.prjid(+)