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条)

报告相同问题?

悬赏问题

  • ¥20 delta降尺度方法,未来数据怎么降尺度
  • ¥15 c# 使用NPOI快速将datatable数据导入excel中指定sheet,要求快速高效
  • ¥15 高德地图点聚合中Marker的位置无法实时更新
  • ¥15 DIFY API Endpoint 问题。
  • ¥20 sub地址DHCP问题
  • ¥15 delta降尺度计算的一些细节,有偿
  • ¥15 Arduino红外遥控代码有问题
  • ¥15 数值计算离散正交多项式
  • ¥30 数值计算均差系数编程
  • ¥15 redis-full-check比较 两个集群的数据出错