select NVL(TM.HENKINGAKU,0) AS HENKINGAKU,
NVL(TH.HENKO_RIYU,' ') AS HENKO_RIYU,
NVL(TH.HENKO_RIYU_CD,' ') AS HENKO_RIYU_CD,
NVL(HK.SENKO_CD,' ') AS SENKO_CD,
NVL(HK.HIKIOTOSHI_YMD,' ') AS HIKIOTOSHI_YMD,
NVL(M4.HIMOKU_RN,' ') AS HIMOKU_RN
from
GN_SP_HENKIN_TBL HK,
GN_SP_HIYO_TBL TH,
GN_SP_KYOTSU_TBL TM,
GN_HIKIATE_TBL HJ,
GN_GAKUNO_TBL M2,
GN_HIMOKU_TBL M4,
GN_GAKUNO_JOHO_TBL GN
where HJ.GAKKO_KBN_CD = 'OI'
and
HJ.NYUGAKU_NENDO = '2000'
and
HJ.GAKUSEKI_NO = '10001'
and
HJ.KASHIKATA_RECORD_KBN = 'H'
and
HJ.YUKOMUKO_JOTAI = '1'
and
GN.GAKKO_KBN_CD = HJ.GAKKO_KBN_CD
and
GN.NYUGAKU_NENDO = HJ.NYUGAKU_NENDO
and
GN.GAKUSEKI_NO = HJ.GAKUSEKI_NO
and
GN.NONYU_YOTEI_NO = HJ.NONYU_YOTEI_NO
and
M2.NENDO = GN.HIKIATESAKI_TEKIYO_NENDO(+)
and
M2.GAKUNO_KBN_CD = HJ.GAKUNO_KBN_CD(+)
and
M4.NENDO = GN.HIKIATESAKI_TEKIYO_NENDO(+)
and
M4.HIMOKU_CD = HJ.KASHIKATA_HIMOKU_CD(+)
会出现错误,ORA-01417 ,就是下面的这连接出错,到底怎么回事啊
M2.NENDO = GN.HIKIATESAKI_TEKIYO_NENDO(+)
and
M2.GAKUNO_KBN_CD = HJ.GAKUNO_KBN_CD(+)
and
M4.NENDO = GN.HIKIATESAKI_TEKIYO_NENDO(+)
and
M4.HIMOKU_CD = HJ.KASHIKATA_HIMOKU_CD(+)
NVL(TH.HENKO_RIYU,' ') AS HENKO_RIYU,
NVL(TH.HENKO_RIYU_CD,' ') AS HENKO_RIYU_CD,
NVL(HK.SENKO_CD,' ') AS SENKO_CD,
NVL(HK.HIKIOTOSHI_YMD,' ') AS HIKIOTOSHI_YMD,
NVL(M4.HIMOKU_RN,' ') AS HIMOKU_RN
from
GN_SP_HENKIN_TBL HK,
GN_SP_HIYO_TBL TH,
GN_SP_KYOTSU_TBL TM,
GN_HIKIATE_TBL HJ,
GN_GAKUNO_TBL M2,
GN_HIMOKU_TBL M4,
GN_GAKUNO_JOHO_TBL GN
where HJ.GAKKO_KBN_CD = 'OI'
and
HJ.NYUGAKU_NENDO = '2000'
and
HJ.GAKUSEKI_NO = '10001'
and
HJ.KASHIKATA_RECORD_KBN = 'H'
and
HJ.YUKOMUKO_JOTAI = '1'
and
GN.GAKKO_KBN_CD = HJ.GAKKO_KBN_CD
and
GN.NYUGAKU_NENDO = HJ.NYUGAKU_NENDO
and
GN.GAKUSEKI_NO = HJ.GAKUSEKI_NO
and
GN.NONYU_YOTEI_NO = HJ.NONYU_YOTEI_NO
and
M2.NENDO = GN.HIKIATESAKI_TEKIYO_NENDO(+)
and
M2.GAKUNO_KBN_CD = HJ.GAKUNO_KBN_CD(+)
and
M4.NENDO = GN.HIKIATESAKI_TEKIYO_NENDO(+)
and
M4.HIMOKU_CD = HJ.KASHIKATA_HIMOKU_CD(+)
会出现错误,ORA-01417 ,就是下面的这连接出错,到底怎么回事啊
M2.NENDO = GN.HIKIATESAKI_TEKIYO_NENDO(+)
and
M2.GAKUNO_KBN_CD = HJ.GAKUNO_KBN_CD(+)
and
M4.NENDO = GN.HIKIATESAKI_TEKIYO_NENDO(+)
and
M4.HIMOKU_CD = HJ.KASHIKATA_HIMOKU_CD(+)
解决方案 »
- sqlplus里面通过啥命令才能显示sort_area_size值呢?
- 这个SQL语句条件中是什么意思?
- 如何在存储过程中判断一个动态表在某一个时间点的总记录是否和上一条一样
- 批次更新问题
- 请教CSDN的各位老大,这个问题的原因以及如何解决,叩谢!
- 怎么能让insert into test values('111'); 执行100遍?
- 关于内连接的一些困惑
- 请问这条SQL语句该怎么写
- 初学求教,Oracle中如何从一个*.dmp文件中恢复一个表的结构?
- 用PB如何在ORCALE中建立表并增加字段?
- 想学pro*c 谁能给我讲讲从编写源码到编译再到执行的整个过程?
- 是不是 oracle 和 IIS 有冲突?
a.b (+) = b.b and a.c (+) = c.c
is not allowed.
到Oracle中运行会报什么错?
你得连接语法是没有错的
NVL(TH.HENKO_RIYU,' ') AS HENKO_RIYU,
NVL(TH.HENKO_RIYU_CD,' ') AS HENKO_RIYU_CD,
NVL(HK.SENKO_CD,' ') AS SENKO_CD,
NVL(HK.HIKIOTOSHI_YMD,' ') AS HIKIOTOSHI_YMD,
NVL(M4.HIMOKU_RN,' ') AS HIMOKU_RN
from
GN_SP_HENKIN_TBL HK,
GN_SP_HIYO_TBL TH,
GN_SP_KYOTSU_TBL TM,
GN_HIKIATE_TBL HJ,
GN_GAKUNO_TBL M2,
GN_HIMOKU_TBL M4,
GN_GAKUNO_JOHO_TBL GN
where HJ.GAKKO_KBN_CD = 'OI'
and
HJ.NYUGAKU_NENDO = '2000'
and
HJ.GAKUSEKI_NO = '10001'
and
HJ.GAKUSEKI_NO = '10001'
and
HJ.KASHIKATA_RECORD_KBN = 'H'
and
HJ.YUKOMUKO_JOTAI = '1'
and
GN.GAKKO_KBN_CD = HJ.GAKKO_KBN_CD
and
GN.NYUGAKU_NENDO = HJ.NYUGAKU_NENDO
and
GN.GAKUSEKI_NO = HJ.GAKUSEKI_NO
and
GN.NONYU_YOTEI_NO = HJ.NONYU_YOTEI_NO
and
M2.NENDO = GN.HIKIATESAKI_TEKIYO_NENDO(+)
and
M2.GAKUNO_KBN_CD = HJ.GAKUNO_KBN_CD(+)
and
M4.NENDO = GN.HIKIATESAKI_TEKIYO_NENDO(+)
and
M4.HIMOKU_CD = HJ.KASHIKATA_HIMOKU_CD(+)
and
HJ.GAKKO_KBN_CD = TM.GAKKO_KBN_CD(+)
and
HJ.NYUGAKU_NENDO = TM.NYUGAKU_NENDO(+)
and
HJ.GAKUSEKI_NO = TM.GAKUSEKI_NO(+)
and
HJ.HIKIATE_SHORI_NO = TM.HIKIATE_SHORI_NO(+)
and
HJ.HIKIATE_SHORI_EDABAN = TM.HIKIATE_SHORI_EDABAN(+)
and
TM.GAKKO_KBN_CD = HK.GAKKO_KBN_CD(+)
and
TM.HIYO_TOKUSHU_NO = HK.HIYO_TOKUSHU_NO(+)
and
TH.GAKKO_KBN_CD = TM.GAKKO_KBN_CD(+)
and
TH.HIYO_TOKUSHU_NO = TM.HIYO_TOKUSHU_NO(+)
and
TH.TOKUSHU_SHONIN_JOTAI = '0'
and
TM.HENKIN_KBN = '1'
是不是这样的呢?
代码如下
select NVL(TM.HENKINGAKU,0) AS HENKINGAKU,
NVL(TH.HENKO_RIYU,' ') AS HENKO_RIYU,
NVL(TH.HENKO_RIYU_CD,' ') AS HENKO_RIYU_CD,
NVL(HK.SENKO_CD,' ') AS SENKO_CD,
NVL(HK.HIKIOTOSHI_YMD,' ') AS HIKIOTOSHI_YMD,
NVL(M4.HIMOKU_RN,' ') AS HIMOKU_RN
from
GN_SP_HENKIN_TBL HK,
GN_SP_HIYO_TBL TH,
GN_SP_KYOTSU_TBL TM,
GN_HIKIATE_TBL HJ,
GN_GAKUNO_TBL M2,
GN_HIMOKU_TBL M4,
GN_GAKUNO_JOHO_TBL GN
where HJ.GAKKO_KBN_CD = 'OI'
and
HJ.NYUGAKU_NENDO = '2000'
and
HJ.GAKUSEKI_NO = '10001'
and
HJ.GAKUSEKI_NO = '10001'
and
HJ.KASHIKATA_RECORD_KBN = 'H'
and
HJ.YUKOMUKO_JOTAI = '1'
and
GN.GAKKO_KBN_CD = HJ.GAKKO_KBN_CD
and
GN.NYUGAKU_NENDO = HJ.NYUGAKU_NENDO
and
GN.GAKUSEKI_NO = HJ.GAKUSEKI_NO
and
GN.NONYU_YOTEI_NO = HJ.NONYU_YOTEI_NO
and
M2.NENDO = GN.HIKIATESAKI_TEKIYO_NENDO(+)
and
M2.GAKUNO_KBN_CD = HJ.GAKUNO_KBN_CD(+)
and
M4.NENDO = GN.HIKIATESAKI_TEKIYO_NENDO--(+)
and
M4.HIMOKU_CD = HJ.KASHIKATA_HIMOKU_CD--(+)
and
HJ.GAKKO_KBN_CD = TM.GAKKO_KBN_CD(+)
and
HJ.NYUGAKU_NENDO = TM.NYUGAKU_NENDO(+)
and
HJ.GAKUSEKI_NO = TM.GAKUSEKI_NO(+)
and
HJ.HIKIATE_SHORI_NO = TM.HIKIATE_SHORI_NO(+)
and
HJ.HIKIATE_SHORI_EDABAN = TM.HIKIATE_SHORI_EDABAN(+)
and
TM.GAKKO_KBN_CD = HK.GAKKO_KBN_CD(+)
and
TM.HIYO_TOKUSHU_NO = HK.HIYO_TOKUSHU_NO(+)
and
TH.GAKKO_KBN_CD = TM.GAKKO_KBN_CD--(+)
and
TH.HIYO_TOKUSHU_NO = TM.HIYO_TOKUSHU_NO--(+)
and
TH.TOKUSHU_SHONIN_JOTAI = '0'
and
TM.HENKIN_KBN = '1'
and
M2.GAKUNO_KBN_CD = HJ.GAKUNO_KBN_CD(+)你的连接都有问题
a.b (+) = b.b and a.c (+) = c.c
is not allowed.