TcLin_
2015-09-10 05:00
采纳率: 100%
浏览 2.3k
已采纳

ORA-00918: column ambiguously defined

SELECT Articm.Fact_No, Articm.Artic_No, Develop_Articm.Artic_No Develop_Articm_Artic_No,
Articm.Style_No, Articm.Brand, Articm.Gender_No, Articm.Color_Cn, Articm.Color_En,
Articm.Dist_Size, Articm.Last_No, Articm.Outsole_No, Articm.Outsole_Col_Cn,
Articm.Outsole_Col_En, Articm.Mat_Type, Articm.Mod_Type, Articm.Obj_Type,
Articm.Cate_No, Articm.Artic_No_In, Articm.Pack_Item, Articm.Odr_Num,
Articm.Artic_Yymm, Articm.No_Color, Articm.Size_Label, Articm.User_No,
Articm.Modi_Date, Articm.Last_No_t, Articm.Outsole_No_t, Articm.Last_No_Sizemk,
Articm.Last_No_t_Sizemk, Articm.Art_Component, Articm.Gwt_Chk_Mk,
Articm.Gwt_Chk_User, Articm.Gwt_Chk_Date, Articm.Mat_Type_Chk, Articm.Upper_Desc,
Articm.Inner_Desc, Articm.Outsole_Desc, Articm.Label_No, Articm.Upc_Code,
Articm.Knife_No, Articm.Size_Color_Desc, Articm.Md_No, Articm.Md_No2,
Articm.Type_Id, Articm.Odr_Make, Articm.Odr_Class, Articm.No_Midkind,
Articm.Com_Style_No, Articm.No_Midkind_d, Articm.Modtype_Bottom,
Articm.Semipro_Type, Articm.Logo_Desc, Articm.Ftc_No, Articm.Hp_Articm,
Articm.Ftc_Mk, Articm.Pre_Make_Mk, Articm.Project_Type, Articm.Artic_Model,
Articm.Season, Articm.Pu_Col_Cn, Articm.Upper_No, Articm.Ship_Days,
Articm.Upper_Chk_Mk, Articm.Outsole_Chk_Mk, Articm.Stop_Mk, Artic_Regcode.Reg_Code,
Stylem.List_No
FROM Articm, Develop_Articm, Stylem, Artic_Regcode
WHERE (Articm.Fact_No = Stylem.Fact_No(+))
AND (Articm.Style_No = Stylem.Style_No(+))
AND (Articm.Fact_No = Develop_Articm.Fact_No(+))
AND (Articm.Artic_No = Develop_Articm.Offi_Artic_No(+))
AND (Articm.Fact_No = Artic_Regcode.Fact_No(+))
AND (Articm.Artic_No = Artic_Regcode.Artic_No(+))
AND (Articm.Fact_No = :As_Fact_No)
AND (Articm.Brand = :As_Brand OR :As_Brand = '%')
AND (Articm.Style_No LIKE :As_Style_No)
AND (Articm.Artic_No LIKE :As_Artic_No)
AND (Nvl(Develop_Articm.Artic_No, '%') LIKE :As_Dev_Artic)

 前端提示錯誤信息:Select Error: ORA-00918: column ambiguously defined
  • 写回答
  • 好问题 提建议
  • 关注问题
  • 收藏
  • 邀请回答

3条回答 默认 最新

  • 安逸的萝卜 2015-09-10 07:24
    已采纳

    ambiguously 未定义,的看表别名,或者是连个表都有这个列,但是未给指定那边表的。

    已采纳该答案
    评论
    解决 无用
    打赏 举报
  • Robot-S 2015-09-10 05:03

    解释:未明确定义的列 原因:select bb.* from (select col1,col2,col3……..coln from tableXX )bb,其中col1,col2,col3..coln肯定有重复的列名称。 例如: SELECT 1 AS cc ,2 AS cc FROM dual;这个语句是没错的。 而下面这个就有问题了: SELECT * FROM (    S......
    答案就在这里:ORA-00918: column ambiguously defined
    ----------------------Hi,地球人,我是问答机器人小S,上面的内容就是我狂拽酷炫叼炸天的答案,除了赞同,你还有别的选择吗?

    评论
    解决 无用
    打赏 举报
  • beaconD 2015-09-10 07:39

    多表操作时,语句中的列名,不明确。
    字段前面加表明.

    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题