这是我在9i中的SQL语句,现在要换到8i中,由于8i不支持left join语句,没办法,只能改写了.
select T1.bgbh,T1.wtdw,T1.symc,
T1.ggxh,T1.jclb,T1.spbh,T1.jcrq,T2.stid,T2.zmc
from whvri_zjz_base T1
left join whvri_zjz_other T2 on T2.stid = T1.stid
where T1.bgbh like '%变压器%' or T1.bgbh like '%变压器%' or T1.wtdw like '%变压器%'
or T1.symc like '%变压器%' or T1.ggxh like '%变压器%'
or T1.jclb like '%变压器%' or T1.spbh like '%变压器%' or T1.jcrq
like '%变压器%' or T1.stid like '%变压器%'
or T1.bgbh like '%变压器%' order by T1.bgbh二个表通过stid来进行关联,T2中只有三个字段 id ,stid,zmc(stid编号对应的名称),我改写后总是出现重复信息,使用group by后也不行.急.
select T1.bgbh,T1.wtdw,T1.symc,
T1.ggxh,T1.jclb,T1.spbh,T1.jcrq,T2.stid,T2.zmc
from whvri_zjz_base T1
left join whvri_zjz_other T2 on T2.stid = T1.stid
where T1.bgbh like '%变压器%' or T1.bgbh like '%变压器%' or T1.wtdw like '%变压器%'
or T1.symc like '%变压器%' or T1.ggxh like '%变压器%'
or T1.jclb like '%变压器%' or T1.spbh like '%变压器%' or T1.jcrq
like '%变压器%' or T1.stid like '%变压器%'
or T1.bgbh like '%变压器%' order by T1.bgbh二个表通过stid来进行关联,T2中只有三个字段 id ,stid,zmc(stid编号对应的名称),我改写后总是出现重复信息,使用group by后也不行.急.
解决方案 »
- 这一条sql语句该怎么写啊?
- 表空间和磁盘问题
- 请大家帮忙看看pl/SQL报错提示应该怎样去修改pl/SQL语句,谢谢
- 如何在sqlplus命令终端显示匿名块的输出
- 请问下这句exp导出语句什么意思?
- oracle816的字符集
- 转一个metalink的关于DBMS_SUPPORT包的说明
- 奇怪的问题:ORA-12545连接错误,进者有分!!
- 初学Oracle,问个简单的问题!
- oracle 12c数据库建立用户总是提示用户名密码错误
- Oracle里是否存在与SQL SERVER 2000数据库一样的功能,即怎么知道连接后所有用户对该数据库所执行的语句操作,在SQL SERVER 2000里好象是叫
- 菜鸟问题,高手帮帮忙啊!
create table t1(id varchar(10),name varchar(10));
create table t2(id varchar(10),name varchar(10));
insert into t1 values('1','a');
insert into t1 values('2','b');
insert into t1 values('3','c');
insert into t1 values('4','d');
insert into t2 values('1','x');
insert into t2 values('2','y');select * from t1,t2 where t1.id=t2.id union
select t1.*,null id ,null name from t1 where t1.id not in(select id from t2)
把or运算全部用()括起来,就OK了
select T1.bgbh,T1.wtdw,T1.symc,
T1.ggxh,T1.jclb,T1.spbh,T1.jcrq,T2.stid,T2.zmc
from whvri_zjz_base T1,whvri_zjz_other T2 where T2.stid = T1.stid(+)
and (T1.bgbh like '%变压器%' or T1.bgbh like '%变压器%' or T1.wtdw like '%变压器%'
or T1.symc like '%变压器%' or T1.ggxh like '%变压器%'
or T1.jclb like '%变压器%' or T1.spbh like '%变压器%' or T1.jcrq
like '%变压器%' or T1.stid like '%变压器%'
or T1.bgbh like '%变压器%') order by T1.bgbh
这是改写的可以运行于oracle 8i的
谢谢大家的回复