u011471803
TcLin_
2015-09-10 05:00

ORA-00918: column ambiguously defined

  • ora-00918

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条回答

为你推荐