这个视图如何建立？在线等待高手指点！

Question

CREATE VIEW VIEW_A(姓名，性别，职务)
            AS
            SELECT 姓名，des，zhiwu 
            FROM A,B,C
            WHERE A.性别(+)=B.code AND A.职务(+)=C.zhiwu;

Answer 1

ORA-01417 a table may be outer joined to at most one other tableCause: a.b (+) = b.b and a.c (+) = c.c is not allowed.Action: Check that this is really what you want, then join b and c first in a view.表可以外部连接到至多一个其它的表

Answer 2

SQL> create table temp1(name varchar2(10) not null,sex number(1),job number(1));表已创建。SQL> create table temp2(code number(1),des varchar2(2));表已创建。SQL> create table temp3(num number(1),zhiwu varchar2(10));表已创建。
SQL> insert into temp1(name,job) values('张三',2);已创建 1 行。SQL> insert into temp1(name,sex) values('李四',2);已创建 1 行。SQL> insert into temp2(code,des) values(1,'男');已创建 1 行。SQL> insert into temp2(code,des) values(2,'女');已创建 1 行。SQL> insert into temp3(num,zhiwu) values(1,'学生');已创建 1 行。SQL> insert into temp3(num,zhiwu) values(2,'教师');已创建 1 行。SQL> commit;提交完成。SQL> create view view_a(name,sex,job) as select t.name,m.des,n.zhiwu from temp1 a,temp2
 b,temp3 c,temp1 d where a.sex(+)=b.code and d.job(+)=c.num;视图已建立。SQL> select * from view_a;NAME       SE JOB
---------- -- ----------
           男 学生
           男 教师
李四       女 学生
李四       女 教师SQL>

Answer 3

这是我要创建的视图
CREATE VIEW VIEW_ZTRYN(BH,JZ,XM,BHCH,XB,CSRQ,SX,SFZH,HJDDZ,XZDDZ,ZJM1,ZJH1,ZJM2,ZJH2,SF,SG,LX,TX,KY,TBBJBW1,TBBJFW1,TBBJSL1,TBBJBJ1,
                      TBBJBW2,TBBJFW2,TBBJSL2,TBBJBJ2,TBBJBW3,TBBJFW3,TBBJSL3,TBBJBJ3,TSTZ1,TSTZ2,TSTZ3,AJBH,AJLB,SFSH,ZTLX,JYAQ,TPRQ,TPFX,FLSD,
                      DBJB,TJLJB,JJ,TJRQ,TJDWQH,TJND,TJSXH,TJJB,LADW,YWXTFL,ZBDW,ZBR,LXFS,DJRQ,DJBTBR,DJSPR,ZHRQ,ZHFS,JJDX,ZHDD,ZHDW,ZHDWXZ,ZWBH,CXBTBR,CXRQ,CXSHR,ZKBZ,SP,SB,XP) AS 
                      SELECT INFOZTRY.BH,INFOZTRY.JZ,INFOZTRY.XM,INFOZTRY.BHCH,DICXB.DES,INFOZTRY.CSRQ,INFOZTRY.SX,INFOZTRY.SFZH,DICXZQHHJDQH.DES||INFOZTRY.HJDXZ,
                             DICXZQHXZDQH.DES||INFOZTRY.XZDXZ,DICZJLX1.DES,INFOZTRY.ZJH1,DICZJLX2.DES,INFOZTRY.ZJH2,DICSF.DES,INFOZTRY.SG,DICLX.DES,DICTX.DES,DICKY.DES,
                             DICTBBJBW1.DES,DICTBBJFW1.DES,DICTBBJSL1.DES,DICTBBJBJ1.DES,DICTBBJBW2.DES,DICTBBJFW2.DES,DICTBBJSL2.DES,DICTBBJBJ2.DES,DICTBBJBW3.DES,
                             DICTBBJFW3.DES,DICTBBJSL3.DES,DICTBBJBJ3.DES,DICTSTZ1.DES,DICTSTZ2.DES,DICTSTZ3.DES,INFOZTRY.AJBH,DICAJLB.DES,INFOZTRY.SFSH,DICZTLX.DES,
                             INFOZTRY.JYAQ,INFOZTRY.TPRQ,INFOZTRY.TPFX,DICFLSD.DES,DICDBJB.DES,DICTJLJB.DES,INFOZTRY.JJ,INFOZTRY.TJRQ,DICXZQHTJDWQH.DES,INFOZTRY.TJND,INFOZTRY.TJSXH,
                             DICTJJB.DES,DICXZQHLADWQH.DES||INFOZTRY.LADWXC,DICYWXT.DES,DICXZQHZBDWQH.DES||INFOZTRY.ZBDW,INFOZTRY.ZBR,INFOZTRY.LXFS,
                             INFOZTRY.DJRQ,INFOZTRY.DJBTBR,INFOZTRY.DJSPR,INFOZTRY.ZHRQ,DICZHFS.DES,INFOZTRY.JJDX,INFOZTRY.ZHDD||INFOZTRY.ZHDDXZ,INFOZTRY.ZHDW,
                             INFOZTRY.ZHDWXZ,INFOZTRY.ZWBH,INFOZTRY.CXBTBR,INFOZTRY.CXRQ,INFOZTRY.CXSHR,INFOZTRY.ZKBZ,INFOZTRY.SP,INFOZTRY.SB,INFOZTRY.XP
                      FROM INFOZTRY,DICXB,DICXZQH DICXZQHHJDQH,DICXZQH DICXZQHXZDQH,DICXZQH DICXZQHTJDWQH,DICXZQH DICXZQHLADWQH,DICXZQH DICXZQHZBDWQH,DICZJLX DICZJLX1,DICZJLX DICZJLX2,DICSF,DICLX,DICTX,DICKY,
                           DICTBBJBW DICTBBJBW1,DICTBBJFW DICTBBJFW1,DICTBBJSL DICTBBJSL1,DICTBBJBJ DICTBBJBJ1,DICTBBJBW DICTBBJBW2,DICTBBJFW DICTBBJFW2,DICTBBJSL DICTBBJSL2,DICTBBJBJ DICTBBJBJ2,
                           DICTBBJBW DICTBBJBW3,DICTBBJFW DICTBBJFW3,DICTBBJSL DICTBBJSL3,DICTBBJBJ DICTBBJBJ3,DICTSTZ DICTSTZ1,DICTSTZ DICTSTZ2,DICTSTZ DICTSTZ3,
                           DICAJLB,DICZTLX,DICFLSD,DICDBJB,DICTJLJB,DICTJJB,DICYWXT,DICZHFS 
                      WHERE INFOZTRY.XB=DICXB.CODE AND INFOZTRY.HJDQH(+)=DICXZQHHJDQH.CODE AND INFOZTRY.XZDQH(+)=DICXZQHXZDQH.CODE AND INFOZTRY.TJDWQH(+)=DICXZQHTJDWQH.CODE 
                            AND INFOZTRY.LADWQH(+)=DICXZQHLADWQH.CODE AND INFOZTRY.ZBDWQH(+)=DICXZQHZBDWQH.CODE AND INFOZTRY.ZJM1(+)=DICZJLX1.CODE AND INFOZTRY.ZJM2(+)=DICZJLX2.CODE AND 
                            INFOZTRY.SF(+)=DICSF.CODE AND INFOZTRY.LX(+)=DICLX.CODE AND INFOZTRY.TX(+)=DICTX.CODE AND INFOZTRY.KY(+)=DICKY.CODE AND 
                            INFOZTRY.TBBJBW1(+)=DICTBBJBW1.CODE AND INFOZTRY.TBBJFW1(+)=DICTBBJFW1.CODE AND INFOZTRY.TBBJSL1(+)=DICTBBJSL1.CODE AND INFOZTRY.TBBJBJ1(+)=DICTBBJBJ1.CODE AND 
                            INFOZTRY.TBBJBW2(+)=DICTBBJBW2.CODE AND INFOZTRY.TBBJFW2(+)=DICTBBJFW2.CODE AND INFOZTRY.TBBJSL2(+)=DICTBBJSL2.CODE AND INFOZTRY.TBBJBF2(+)=DICTBBJBJ2.CODE AND 
                            INFOZTRY.TBBJBW3(+)=DICTBBJBW3.CODE AND INFOZTRY.TBBJFW3(+)=DICTBBJFW3.CODE AND INFOZTRY.TBBJSL3(+)=DICTBBJSL3.CODE AND INFOZTRY.TBBJBJ3(+)=DICTBBJBJ3.CODE AND 
                            INFOZTRY.TSTZ1(+)=DICTSTZ1.CODE AND INFOZTRY.TSTZ2(+)=DICTSTZ2.CODE AND INFOZTRY.TSTZ3(+)=DICTSTZ3.CODE AND INFOZTRY.AJLB(+)=DICAJLB.CODE AND INFOZTRY.ZTLX(+)=DICZTLX.CODE AND 
                            INFOZTRY.FLSD(+)=DICFLSD.CODE AND INFOZTRY.DBJB(+)=DICDBJB.CODE AND INFOZTRY.TJLJB(+)=DICTJLJB.CODE AND INFOZTRY.TJJB(+)=DICTJJB.CODE AND INFOZTRY.YWXTFL(+)=DICYWXT.CODE 
                            AND INFOZTRY.ZHFS(+)=DICZHFS.CODE;出现了一下错误提示：
-01417: 表可以外部连接到至多一个其它的表
这可如何是好呀？求助！