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

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 未定义,的看表别名,或者是连个表都有这个列,但是未给指定那边表的。

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 ue5 .3之前好好的现在只要是激活关卡就会崩溃
  • ¥50 MATLAB实现圆柱体容器内球形颗粒堆积
  • ¥15 python如何将动态的多个子列表,拼接后进行集合的交集
  • ¥20 vitis-ai量化基于pytorch框架下的yolov5模型
  • ¥15 如何实现H5在QQ平台上的二次分享卡片效果?
  • ¥15 python爬取bilibili校园招聘网站
  • ¥30 求解达问题(有红包)
  • ¥15 请解包一个pak文件
  • ¥15 不同系统编译兼容问题
  • ¥100 三相直流充电模块对数字电源芯片在物理上它必须具备哪些功能和性能?