求救各位大侠!!!!!!!!!!!!!(100分)

  • 主题发起人 主题发起人 anson
  • 开始时间 开始时间
A

anson

Unregistered / Unconfirmed
GUEST, unregistred user!
在orale运行时报ora-01445的错误<br>SELECT 'O',ofa01<br>&nbsp;FROM ofb_file &nbsp;JOIN ofa_file ON ofa01=ofb01 &nbsp;<br>&nbsp;LEFT JOIN oga_file ON oga01=ofa011 &nbsp;<br>&nbsp;LEFT JOIN tc_ofz_file ON ofz01=ofa01 <br>&nbsp;JOIN ima_file ON ofb04 =ima01 <br>&nbsp;LEFT JOIN occ_file ON occ01=ofa03 &nbsp; <br>&nbsp;LEFT JOIN obk_file ON ofa03=obk02 AND ofb04=obk01 &nbsp;<br>&nbsp;LEFT JOIN oah_file ON oah01=ofa31 <br>&nbsp;LEFT JOIN gsdtwz.oeb_file ON oeb01=ofb31 AND oeb03=ofb32 <br>&nbsp;LEFT JOIN gsdtwz.tc_ocx_file ON ocx01=ofb31 <br>&nbsp;WHERE ofaconf &lt;&gt; 'X' &nbsp; &nbsp;<br>&nbsp;AND ofa011 = 'SI2-07120004' &nbsp; <br>-- AND ofb13*(ocx47-100)/100 &lt;&gt; 0
 
ora-01445 无法从没有键值保存表的连接视图中选择ROWID <br>还不明白吗? 你那一堆连接不全是主键外键对应的连接
 

Similar threads

I
回复
0
查看
853
import
I
I
回复
0
查看
760
import
I
I
回复
0
查看
776
import
I
I
回复
0
查看
699
import
I
后退
顶部